注意string类型的比较，string当做数据类型去比较

2019独角兽企业重金招聘Python工程师标准>>>

stirng如果想直接和数据比，比较的右边值不带引号就能按数据比较了，hive会强转string为int进行比较

例如：'3'>2

cat /tmp/test/name.txt

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

create table test123(name string)

LOAD DATA LOCAL INPATH '/tmp/test/name.txt' OVERWRITE INTO TABLE tmp1.test123 

1

10

11

12

13

14

15

16

17

2

3

4

5

6

7

8

9

select * from test123 order by name;

1

10

11

12

13

14

15

16

17

2

3

4

5

6

7

8

9

select * from test123 where name >9;

10

11

12

13

14

15

16

17

hive> select * from test123 where name >'9';

no result

hive> select * from test123 where name >'10';

2

3

4

5

6

7

8

9

11

12

13

14

15

16

17

转载于:https://my.oschina.net/forrest420/blog/279549