can you share your create table statement ?
On Fri, Feb 21, 2014 at 2:55 PM, Jone Lura <jone.l...@ecc.no> wrote: > 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 > -- Nitin Pawar