Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive, mail # user - Hive/HBase integration issue.


+
Vivek Mishra 2010-11-18, 05:56
Copy link to this message
-
Re: Hive/HBase integration issue.
afancy 2010-11-18, 09:00
Hi,

Does  the INSERT clause have to include the OVERWRITE, which means that the
new data will overwrite the previous data?  How to implement the indeed
INSERT operation, instead of OVERWRITE?
BTW: How to implement the DELETE operator? thanks

afancy
-------------------------------------------------------
hive> insert OVERWRITE table  pagedim select 0, url, strToint('2'),
'domain', 'serversion' from downloadlog;
Total MapReduce jobs = 2
Launching Job 1 out of 2
Number of reduce tasks is set to 0 since there's no reduce operator
Starting Job = job_201011121525_0006, Tracking URL http://localhost:50030/jobdetails.jsp?jobid=job_201011121525_0006
Kill Command = /home/xiliu/hadoop-0.20.2/bin/../bin/hadoop job
 -Dmapred.job.tracker=localhost:54311 -kill job_201011121525_0006
2010-11-18 09:55:52,155 Stage-1 map = 0%,  reduce = 0%
2010-11-18 09:55:55,169 Stage-1 map = 100%,  reduce = 0%
2010-11-18 09:55:58,200 Stage-1 map = 100%,  reduce = 100%
Ended Job = job_201011121525_0006
Ended Job = 487027960, job is filtered out (removed at runtime).
Launching Job 2 out of 2
Number of reduce tasks is set to 0 since there's no reduce operator
Starting Job = job_201011121525_0007, Tracking URL http://localhost:50030/jobdetails.jsp?jobid=job_201011121525_0007
Kill Command = /home/xiliu/hadoop-0.20.2/bin/../bin/hadoop job
 -Dmapred.job.tracker=localhost:54311 -kill job_201011121525_0007
2010-11-18 09:56:04,701 Stage-2 map = 0%,  reduce = 0%
2010-11-18 09:56:07,723 Stage-2 map = 100%,  reduce = 0%
2010-11-18 09:56:10,751 Stage-2 map = 100%,  reduce = 100%
Ended Job = job_201011121525_0007
Loading data to table pagedim
1000 Rows loaded to pagedim
OK
Time taken: 23.194 seconds
hive> insert table  pagedim select 0, url, strToint('2'), 'domain',
'serversion' from downloadlog;
FAILED: Parse Error: line 1:7 mismatched input 'table' expecting OVERWRITE
in insert clause
+
John Sichi 2010-11-18, 19:33
+
John Sichi 2010-11-18, 19:32
+
Vivek Mishra 2010-11-19, 05:06
+
Vivek Mishra 2010-11-24, 08:02