Like语句代码,Hive代码库,德仔网

代码语言

代码分类

【Hive】 Like语句

作者:泰昌 / 发布于2016/11/28/ 690

hive> select * from salaries_partition where playerid like '%AL' limit 10;  
Total jobs = 1  
Launching Job 1 out of 1  
Number of reduce tasks is set to 0 since there's no reduce operator  
Starting Job = job_1475137014881_0010, Tracking URL = http://hadoopwy1:8088/proxy/application_1475137014881_0010/  
Kill Command = /usr/local/hadoop2/bin/hadoop job  -kill job_1475137014881_0010  
Hadoop job information for Stage-1: number of mappers: 1; number of reducers: 0  
2016-09-29 03:56:20,951 Stage-1 map = 0%,  reduce = 0%  
2016-09-29 03:56:37,598 Stage-1 map = 100%,  reduce = 0%, Cumulative CPU 1.89 sec  
MapReduce Total cumulative CPU time: 1 seconds 890 msec  
Ended Job = job_1475137014881_0010  
MapReduce Jobs Launched:  
Job 0: Map: 1   Cumulative CPU: 1.89 sec   HDFS Read: 44567 HDFS Write: 0 SUCCESS  
Total MapReduce CPU Time Spent: 1 seconds 890 msec  
OK  
Time taken: 29.258 seconds

试试其它关键字

同语言下

可能有用的

泰昌贡献的其它代码(12)