You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Jone Lura <jo...@ecc.no> on 2014/02/21 10:25:37 UTC
Hive + JDBC issues
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
Re: Hive + JDBC issues
Posted by Nitin Pawar <ni...@gmail.com>.
great
On 21 Feb 2014 15:36, "Jone Lura" <jo...@ecc.no> wrote:
> 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 <ni...@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 <jo...@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 <ni...@gmail.com> wrote:
>>
>> can you share your create table statement ?
>>
>>
>> On Fri, Feb 21, 2014 at 2:55 PM, Jone Lura <jo...@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
>
>
>
Re: Hive + JDBC issues
Posted by Jone Lura <jo...@ecc.no>.
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 <ni...@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 <jo...@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 <ni...@gmail.com> wrote:
>
>> can you share your create table statement ?
>>
>>
>> On Fri, Feb 21, 2014 at 2:55 PM, Jone Lura <jo...@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
Re: Hive + JDBC issues
Posted by Nitin Pawar <ni...@gmail.com>.
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 <jo...@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 <ni...@gmail.com> wrote:
>
> can you share your create table statement ?
>
>
> On Fri, Feb 21, 2014 at 2:55 PM, Jone Lura <jo...@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
Re: Hive + JDBC issues
Posted by Jone Lura <jo...@ecc.no>.
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 <ni...@gmail.com> wrote:
> can you share your create table statement ?
>
>
> On Fri, Feb 21, 2014 at 2:55 PM, Jone Lura <jo...@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
Re: Hive + JDBC issues
Posted by Nitin Pawar <ni...@gmail.com>.
can you share your create table statement ?
On Fri, Feb 21, 2014 at 2:55 PM, Jone Lura <jo...@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