unable to load tweet table



0

please see the screenshot of the error i am getting



4 Answer(s)


0

Rosemary,

Did you load both hives jar files? hives-serdes.jar and hives-serdes-1.0-SNAPSHOT.jar. 

I am not sure they are related to your error, but that was a big solution for me. 

 

 


0

@Jorge, yes you are right, if she doesn't have added the hive-serde error but that would be "file format exception". Here the error is about the partition of the table. Thanks.

Hi Rosemary,

As you have define the partitioned during table creation. You need to specify it before loading the data.

Sample command:

hive> alter table tweets_partioned add partition (year=2016, month=08, dt=24, dthour=06);

Please correct the table name if I had written incorrectly and mention the partitioned values correctly.

After this query, run your LOAD query followed by Select statements.

Hope this helps.

Thanks.


0

this is error am still getting

hive> LOAD DATA LOCAL INPATH '/home/cloudera/tweets'INTO TABLE tweets_partionedd;

FAILED: SemanticException [Error 10062]: Need to specify partition columns because the destination table is partitioned

 

am not getting any help from you guys.

i keep getting the same answer 

PLEASE HELP ME FINISH THIS PROJECT. I CAN'T FINISH THE PROJECT BECAUSE OF THE ERROR I KEEP GETTING


0

Hi Rosemary,

Please share all the command you used. I will correct the command and share the working commands with you.

Hope this helps.

Thanks.

Your Answer

Click on this code-snippet-icon icon to add code snippet.

Upload Files (Maximum image file size - 1.5 MB, other file size - 10 MB, total size - not more than 50 MB)

Email
Password