Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Hive not responding for Twitter analysis

Re: Hive not responding for Twitter analysis

Contributor

Please help me on this..

 

Thanks,

Syam.

Re: Hive not responding for Twitter analysis

Cloudera Employee

Hi syamsri,

 

This seems like a permission issue. As indicated by the exception, please verify if appropriate write

permissions exist for table directory.

 

Thanks.

Re: Hive not responding for Twitter analysis

Contributor

Hi Mohit,

 

Thanks for the reply,

I have given all permissions for the tweets folder.

 

Thanks,

Syam.

Re: Hive not responding for Twitter analysis

Champion

if it is just a vm that you are playin around , disable the security in the hdfs-site.xml 

 

 by setting the below property to false in hdfs-site.xml

 

<property>
<name>dfs.permissions.enabled</name>
<value>false</value>
</property>

After setting please restart the all.

 

OR 

 

sudo -u hdfs hadoop fs -chmod  -R 777  /solr/twitter_demo/core_node1/data/tlog

 

you have to give the 

Re: Hive not responding for Twitter analysis

Contributor

Hi Guna,

 

Thanks again for the reply,

The Stated property is not there in hdfs-site.xml .

Shall i add ?

 

I am not using solr .

I want Hive analysis on twitter data which came via Flume.

 

Thanks,

Syam.

Re: Hive not responding for Twitter analysis

Champion

Yes please add the property if it is not there and if you are ok in disabling the security

also restart everything , in order to publish the change in the hdfs-site.xml

Re: Hive not responding for Twitter analysis

Contributor

Hi Guna,

 

I have added the property as you stated and restarted.

But this error is repeating.

2016-11-15_1419.png

 

Appreciate your help.

Thanks,

Syam.

Re: Hive not responding for Twitter analysis

Champion

This time it didnt complain about the permission error that you got last time.

please issue the below commands. 

 

MSCK REPAIR TABLE table_name;
analyze table table_name  compute statistics;

the above should refresh the metadata and try select * from tablename;

 

 

Re: Hive not responding for Twitter analysis

Contributor

Hi Guna,

 

Thanks again,

Please check the scrreen shots. Same error

 

2016-11-17_0331.png2016-11-17_0332_002.png2016-11-17_0332.png2016-11-17_0332_001.png2016-11-17_0334.png

Thanks,

Syam.

Highlighted

Re: Hive not responding for Twitter analysis

Champion

Could you verify your hive/lib folder whether you have the  hive-serdes-1.0-SNAPSHOT.jar , if not please download it and add it and please excute the select statement.