Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive, mail # user - "show table" throwing strange error


Copy link to this message
-
Re: "show table" throwing strange error
Mohammad Tariq 2013-06-20, 02:04
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:
>>