Home | About | Sematext search-lucene.com search-hadoop.com
 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
Copy link to this message
-
Re: "show table" throwing strange error
Mohammad Tariq 2013-06-20, 01:59
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:
>>>
>>>> Did you check in your hive query log under /tmp to see if it says
>>>> something in the log ?
>>>>
>>>>
>>>> Sent from my iPhone
>>>>
>>>> On Jun 19, 2013, at 5:53 PM, Mohammad Tariq <[EMAIL PROTECTED]> wrote:
>>>>
>>>> Hello list,
>>>>
>>>>          I have a hive(0.9.0) setup on my Ubuntu box running
>>>> hadoop-1.0.4. Everything was going smooth till now. But today when I issued
>>>> *show tables* I got some strange error on the CLI. Here is the error :
+
Mohammad Tariq 2013-06-20, 02:04
+
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