Thank you!
By adding the ROW FORMAT DELIMITED FIELDS TERMINATED BY '\tâ to the create
statement it finally worked. I also changed the delimiter in the a.txt file to
match statement.
In addition I had to delete the ship_type created using the Hive CLI and create
the table through the JDBC driver.
Best regards,
Jone
On 21 Feb 2014, at 10:50, Nitin Pawar <nitinpawar...@gmail.com> wrote:
> can you just cat the file a.txt as well.
>
> You may have to create table as
>
> "create table ship_type(id int, name string) ROW FORMAT DELIMITED FIELDS
> TERMINATED BY '\t';
> If it is tab separated or use proper field separator you have.
>
> You get incorrect results when your table definition does not match with your
> actual data
>
>
> On Fri, Feb 21, 2014 at 3:05 PM, Jone Lura <jone.l...@ecc.no> wrote:
> I used this from the example;
>
> stmt.execute("create table " + tableName + " (key int, value string)â);
>
> In my application it is very similar;
>
> stmt.execute("create table ship_type (id int, name string)â);
>
>
> On 21 Feb 2014, at 10:27, Nitin Pawar <nitinpawar...@gmail.com> wrote:
>
>> 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
>
>
>
>
> --
> Nitin Pawar
