>
> Also - as a sanity check - can you please check hadoop dfs -cat /
> data/sample/* (to make sure data got loaded/moved into that dir)
>
> -Original Message-
> From: Josh Ferguson [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, November 25, 2008 7:03 PM
> To: h
PROTECTED]> wrote:
congrats!! :)
please do file a JIRA for this. We will fix this as soon as possible..
Ashish
From: Josh Ferguson [EMAIL PROTECTED]
Sent: Wednesday, November 26, 2008 12:44 AM
To: hive-user@hadoop.apache.org
Subject: Re: Troubl
t; wrote:
congrats!! :)
please do file a JIRA for this. We will fix this as soon as possible..
Ashish
From: Josh Ferguson [EMAIL PROTECTED]
Sent: Wednesday, November 26, 2008 12:44 AM
To: hive-user@hadoop.apache.org
Subject: Re: Trouble Loading Into External T
Ferguson [EMAIL PROTECTED]
Sent: Wednesday, November 26, 2008 12:44 AM
To: hive-user@hadoop.apache.org
Subject: Re: Trouble Loading Into External Table
I got it! The combination I got to work was the following:
CREATE EXTERNAL TABLE basic
(actor_id INT, actee_id INT, properties MAP)
ROW FORMAT DELI
congrats!! :)
please do file a JIRA for this. We will fix this as soon as possible..
Ashish
From: Josh Ferguson [EMAIL PROTECTED]
Sent: Wednesday, November 26, 2008 12:44 AM
To: hive-user@hadoop.apache.org
Subject: Re: Trouble Loading Into External Table
le/* (to make sure data got loaded/moved into that dir)
-Original Message-
From: Josh Ferguson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 25, 2008 7:03 PM
To: hive-user@hadoop.apache.org
Subject: Re: Trouble Loading Into External Table
hive> CREATE EXTERNAL TABLE activi
inal Message-
From: Josh Ferguson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 25, 2008 7:03 PM
To: hive-user@hadoop.apache.org
Subject: Re: Trouble Loading Into External Table
hive> CREATE EXTERNAL TABLE activity_test
(occurred_at INT, actor_id INT, actee_id INT, properties
MAP)
:03 PM
To: hive-user@hadoop.apache.org
Subject: Re: Trouble Loading Into External Table
hive> CREATE EXTERNAL TABLE activity_test
(occurred_at INT, actor_id INT, actee_id INT, properties
MAP)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY '124'
COLLECTION ITEMS TERMINATED BY '44&#
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 25, 2008 7:03 PM
To: hive-user@hadoop.apache.org
Subject: Re: Trouble Loading Into External Table
hive> CREATE EXTERNAL TABLE activity_test
(occurred_at INT, actor_id INT, actee_id INT, properties
MAP)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY
d into that dir)
-Original Message-
From: Josh Ferguson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 25, 2008 7:03 PM
To: hive-user@hadoop.apache.org
Subject: Re: Trouble Loading Into External Table
hive> CREATE EXTERNAL TABLE activity_test
> (occurred_at INT, actor_id INT, actee_id
hive> CREATE EXTERNAL TABLE activity_test
> (occurred_at INT, actor_id INT, actee_id INT, properties
MAP)
> ROW FORMAT DELIMITED
> FIELDS TERMINATED BY '124'
> COLLECTION ITEMS TERMINATED BY '44'
> MAP KEYS TERMINATED BY '58'
> LINES TERMINATED BY '10'
> STORED AS TE
Can you try putting the ascii value within quotes, so for example FIELDS
TERMINATED BY '124' etc...
You can also look at the following file in the source to see an example of how
this is done
ql/src/test/queries/clientpositive/input_dynamicserde.q
Ashish
-Original Message-
From: Josh
12 matches
Mail list logo
