Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive >> mail # user >> "show table" throwing strange error


+
Mohammad Tariq 2013-06-20, 00:53
+
Anurag Tangri 2013-06-20, 01:23
+
Mohammad Tariq 2013-06-20, 01:30
+
Mapred Learn 2013-06-20, 01:36
+
Mohammad Tariq 2013-06-20, 01:42
+
Mohammad Tariq 2013-06-20, 01:44
+
Anurag Tangri 2013-06-20, 01:51
+
Mohammad Tariq 2013-06-20, 01:59
Copy link to this message
-
Re: "show table" throwing strange error
That error is gone after I recreated hive-site.xml and restarted hive. But
now there seems to be some problem with metastore settings. It's not going
to mysql.

Anyways, thank you both for the help.

Warm Regards,
Tariq
cloudfront.blogspot.com
On Thu, Jun 20, 2013 at 7:29 AM, Mohammad Tariq <[EMAIL PROTECTED]> wrote:

> Yes. It's up and running with all the required permissions.
>
> Warm Regards,
> Tariq
> cloudfront.blogspot.com
>
>
> On Thu, Jun 20, 2013 at 7:21 AM, Anurag Tangri <[EMAIL PROTECTED]>wrote:
>
>> Looks like you use MySQL.
>>
>> Can you check if your MySQL still up ?
>>
>> and permissions on your hive metastore db ?
>>
>> Sent from my iPhone
>>
>> On Jun 19, 2013, at 6:44 PM, Mohammad Tariq <[EMAIL PROTECTED]> wrote:
>>
>> It actually seems to be ignoring hive-site.xml. No effect of the
>> properties set in hive-site.xml file.
>>
>> Warm Regards,
>> Tariq
>> cloudfront.blogspot.com
>>
>>
>> On Thu, Jun 20, 2013 at 7:12 AM, Mohammad Tariq <[EMAIL PROTECTED]>wrote:
>>
>>> It looks OK to me,
>>>
>>> <configuration>
>>>
>>> <property>
>>>   <name>javax.jdo.option.ConnectionURL</name>
>>>   <value>jdbc:mysql://localhost:3306/hive?*createDatabaseIfNotExist*
>>> =true</value>
>>> </property>
>>>
>>> <property>
>>>   <name>javax.jdo.option.ConnectionDriverName</name>
>>>   <value>com.mysql.jdbc.Driver</value>
>>> </property>
>>>
>>> <property>
>>>   <name>javax.jdo.option.ConnectionUserName</name>
>>>   <value>apache</value>
>>> </property>
>>>
>>> <property>
>>>   <name>javax.jdo.option.ConnectionPassword</name>
>>>   <value>password</value>
>>> </property>
>>>
>>> <property>
>>>   <name>hive.metastore.local</name>
>>>   <value>true</value>
>>> </property>
>>>
>>> <property>
>>>     <name>hive.exec.scratchdir</name>
>>>     <value>/hadoop/hive-tmp</value>
>>>     <description>Scratch space for Hive jobs</description>
>>> </property>
>>>
>>> </configuration>
>>>
>>> Anything wrong here?
>>>
>>> Thank you.
>>>
>>> Warm Regards,
>>> Tariq
>>> cloudfront.blogspot.com
>>>
>>>
>>> On Thu, Jun 20, 2013 at 7:06 AM, Mapred Learn <[EMAIL PROTECTED]>wrote:
>>>
>>>> Can you also check your hive site XML ?
>>>> Is it properly formatted and connection strings correct ?
>>>>
>>>> Sent from my iPhone
>>>>
>>>> On Jun 19, 2013, at 6:30 PM, Mohammad Tariq <[EMAIL PROTECTED]> wrote:
>>>>
>>>> Hello Anurag,
>>>>
>>>>    Thank you for the quick response. Log files is full of such lines
>>>> along with a trace that says it is some parsing related issue. But the
>>>> strange thing is that here I can see *'\00' *but on the CLI it was
>>>> just *' '. *I am wondering what's with wrong with *show tables;*
>>>> *
>>>> *
>>>> line 1:79 character '\00' not supported here
>>>> line 1:80 character '\00' not supported here
>>>>
>>>> at
>>>> org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:446)
>>>>  at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:416)
>>>> at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:336)
>>>>  at org.apache.hadoop.hive.ql.Driver.run(Driver.java:909)
>>>> at
>>>> org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:258)
>>>>  at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:215)
>>>> at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:406)
>>>>  at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:689)
>>>> at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:557)
>>>>  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>>> at
>>>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
>>>>  at
>>>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>>>> at java.lang.reflect.Method.invoke(Method.java:601)
>>>>  at org.apache.hadoop.util.RunJar.main(RunJar.java:156)
>>>>
>>>> Thanks again.
>>>>
>>>> Warm Regards,
>>>> Tariq
>>>> cloudfront.blogspot.com
>>>>
>>>>
>>>> On Thu, Jun 20, 2013 at 6:53 AM, Anurag Tangri <[EMAIL PROTECTED]
>>>> > wrote:
>>
+
Sunita Arvind 2013-06-20, 03:13
+
Mohammad Tariq 2013-06-20, 11:28
+
Sanjay Subramanian 2013-06-20, 19:33
+
Mohammad Tariq 2013-06-20, 19:52
+
Sanjay Subramanian 2013-06-21, 19:17
+
kulkarni.swarnim@...) 2013-06-21, 20:56
+
shashwat shriparv 2013-06-22, 09:58
+
Mohammad Tariq 2013-07-01, 02:43
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB