Friendly greetings ! I am very frustrated about hive. i like the program but i find a problem avery day i try to use it and i can't find any support on irc. so here i am !
1st problem : hive> create table top_test like top; OK hive> load data local inpath '/home/ker2x/over-blog/archive-20101213/_top.sql' into table top_test; Copying data from file:/home/ker2x/over-blog/archive-20101213/_top.sql Loading data to table top_test OK Time taken: 0.832 seconds hive> select count(1) from top_test; ... OK 0 if the file loaded being with a "_" there is no error but it's impossible to do any query on it. of course if i do : hive> load data local inpath '/home/ker2x/over-blog/archive-20101213/top.sql' into table top_test; Copying data from file:/home/ker2x/over-blog/archive-20101213/top.sql Loading data to table top_test OK Time taken: 0.908 seconds hive> select count(1) from top_test; ... OK 1460112 Time taken: 34.779 seconds it works without problem ... The first time i got this problem i lost many hours (loading + query) because the imported file was tens of GB :( 2nd problem : hive> create table testing (data string); FAILED: Parse Error: line 1:22 mismatched input 'data' expecting Identifier in column specification can't create a column named "data". is it documented anywhere ? same problem with a column named "date". same problem with a column named "comment". same problem with a column named "timestamp". 3rd problem : i'm loading a big file, no problem. now i run *any* query on this table and here is the result : http://pastebin.com/mE8Gzdbq Look like a line or a column doesn't have the expected format. But... which line ? which column ? i'm on this problem since days :((( Can you help please ? thank you. -- Laurent "ker2x" Laborde Sysadmin & DBA at http://www.over-blog.com/
