great
On 21 Feb 2014 15:36, "Jone Lura" 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 usin
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 drive
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
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 wrote:
> can you share your create table statement ?
can you share your create table statement ?
On Fri, Feb 21, 2014 at 2:55 PM, Jone Lura 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
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 n