Hi, I am new with Hadoop and Hive, and I am trying to figure out what is = going wrong.
In my application I connect successfully to the Hive and I am able to = load data into it. When I try to run a select statement however, things are not as I = expected. The select query returns the correct number of rows, but the values are = 0 for int and null for String. I also tried the HiveJdbcClient.java code found on the wiki page; = https://cwiki.apache.org/confluence/display/Hive/HiveServer2+Clients#HiveS= erver2Clients-JDBCClientSampleCode, and I am experiencing the same = problems. Running: show tables 'testHiveDriverTable' testhivedrivertable Running: describe testHiveDriverTable key int =20 value string =20 Running: load data local inpath '/tmp/a.txt' into table = testHiveDriverTable Running: select * from testHiveDriverTable 0 null 0 null Running: select count(1) from testHiveDriverTable The content of a.txt is as follows; 1\001Test 2\001Test1 Does anyone know what could possibly be the reason for this? Hadoop and Hive are locally installed, but not embedded. Best regards, Jone
