hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "kulkarni.swarnim@gmail.com" <kulkarni.swar...@gmail.com>
Subject Re: "show table" throwing strange error
Date Fri, 21 Jun 2013 20:56:16 GMT
More often than not in my experience is caused by a malformed
hive-site.xml(or hive-default.xml). When this happened to me, it was
because I somehow had tab characters in my hive-site.xml. Try dropping the
file(s) and recreate with appropriate formatting.


On Fri, Jun 21, 2013 at 2:17 PM, Sanjay Subramanian <
Sanjay.Subramanian@wizecommerce.com> wrote:

>  Can u stop following services
> hive-server
> hive-meta-store
> Hive-server2 (if u r running that)
>
>  Move current hive.log some place else
>
>  Start following services
>  hive-server
> hive-meta-store
> Hive-server2 (if u r running that)
>
>
>  And check hive.log ?
>
>  Also can u paste the CREATE TABLe script verbatim here…I feel if u are
> using some custom INPUTFORMAT / OUTPUTFORMAT class  that have to be
> specified in quotes…u may have to be *escape* that
>
>  Plus try and add a semicolon to the end of the create table script ...
>
>  sanjay
>
>   From: Mohammad Tariq <dontariq@gmail.com>
> Reply-To: "user@hive.apache.org" <user@hive.apache.org>
> Date: Thursday, June 20, 2013 12:52 PM
>
> To: user <user@hive.apache.org>
> Subject: Re: "show table" throwing strange error
>
>   Thank you for looking into it Sanjay. "show tables" is working fine
> from both Ubuntu and Hive shell. But i'm getting the same error as
> yesterday when i'm running "create table", which is :
>
>  line 1:30 character '' not supported here
> line 1:31 character '' not supported here
> line 1:32 character '' not supported here
> line 1:33 character '' not supported here
> line 1:34 character '' not supported here
> line 1:35 character '' not supported here
> line 1:36 character '' not supported here
> line 1:37 character '' not supported here
> line 1:38 character '' not supported here
> line 1:39 character '' not supported here
> line 1:40 character '' not supported here
> line 1:41 character '' not supported here
> line 1:42 character '' not supported here
> .
> .
> .
> .
>
>  Also, I have noticed 1 strange thing. "hive.log" is totally messed up.
> Looks like logs are getting written in some binary encoding. I have
> attached a snapshot of the same. Any idea?
>
>  Warm Regards,
> Tariq
> cloudfront.blogspot.com
>
>
> On Fri, Jun 21, 2013 at 1:03 AM, Sanjay Subramanian <
> Sanjay.Subramanian@wizecommerce.com> wrote:
>
>>  Can u try from your ubuntu command prompt
>> $> hive -e "show tables"
>>
>>   From: Mohammad Tariq <dontariq@gmail.com>
>> Reply-To: "user@hive.apache.org" <user@hive.apache.org>
>> Date: Thursday, June 20, 2013 4:28 AM
>> To: user <user@hive.apache.org>
>>
>> Subject: Re: "show table" throwing strange error
>>
>>   Thank you for the response ma'am. It didn't help either.
>>
>>  Warm Regards,
>> Tariq
>> cloudfront.blogspot.com
>>
>>
>> On Thu, Jun 20, 2013 at 8:43 AM, Sunita Arvind <sunitarvind@gmail.com>wrote:
>>
>>>  Your issue seems familiar. Try logging out of hive session and
>>> re-login.
>>>
>>>  Sunita
>>>
>>>
>>> On Wed, Jun 19, 2013 at 8:53 PM, Mohammad Tariq <dontariq@gmail.com>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 :
>>>>
>>>>  hive> show tables;
>>>> FAILED: Parse Error: line 1:0 character '' not supported here
>>>> line 1:1 character '' not supported here
>>>> line 1:2 character '' not supported here
>>>> line 1:3 character '' not supported here
>>>> line 1:4 character '' not supported here
>>>> line 1:5 character '' not supported here
>>>> line 1:6 character '' not supported here
>>>> line 1:7 character '' not supported here
>>>> line 1:8 character '' not supported here
>>>> line 1:9 character '' not supported here
>>>> line 1:10 character '' not supported here
>>>> line 1:11 character '' not supported here
>>>> line 1:12 character '' not supported here
>>>> line 1:13 character '' not supported here
>>>> line 1:14 character '' not supported here
>>>> line 1:15 character '' not supported here
>>>> line 1:16 character '' not supported here
>>>> line 1:17 character '' not supported here
>>>> line 1:18 character '' not supported here
>>>> line 1:19 character '' not supported here
>>>> line 1:20 character '' not supported here
>>>> line 1:21 character '' not supported here
>>>> line 1:22 character '' not supported here
>>>> line 1:23 character '' not supported here
>>>> line 1:24 character '' not supported here
>>>> line 1:25 character '' not supported here
>>>> line 1:26 character '' not supported here
>>>> line 1:27 character '' not supported here
>>>> line 1:28 character '' not supported here
>>>> line 1:29 character '' not supported here
>>>> line 1:30 character '' not supported here
>>>> line 1:31 character '' not supported here
>>>> line 1:32 character '' not supported here
>>>> line 1:33 character '' not supported here
>>>> line 1:34 character '' not supported here
>>>> line 1:35 character '' not supported here
>>>> line 1:36 character '' not supported here
>>>> line 1:37 character '' not supported here
>>>> line 1:38 character '' not supported here
>>>> line 1:39 character '' not supported here
>>>> line 1:40 character '' not supported here
>>>> line 1:41 character '' not supported here
>>>> line 1:42 character '' not supported here
>>>> line 1:43 character '' not supported here
>>>> line 1:44 character '' not supported here
>>>> line 1:45 character '' not supported here
>>>> line 1:46 character '' not supported here
>>>> line 1:47 character '' not supported here
>>>> line 1:48 character '' not supported here
>>>> line 1:49 character '' not supported here
>>>> line 1:50 character '' not supported here
>>>> line 1:51 character '' not supported here
>>>> line 1:52 character '' not supported here
>>>> line 1:53 character '' not supported here
>>>> line 1:54 character '' not supported here
>>>> line 1:55 character '' not supported here
>>>> line 1:56 character '' not supported here
>>>> line 1:57 character '' not supported here
>>>> line 1:58 character '' not supported here
>>>> line 1:59 character '' not supported here
>>>> line 1:60 character '' not supported here
>>>> line 1:61 character '' not supported here
>>>> line 1:62 character '' not supported here
>>>> line 1:63 character '' not supported here
>>>> line 1:64 character '' not supported here
>>>> line 1:65 character '' not supported here
>>>> line 1:66 character '' not supported here
>>>> line 1:67 character '' not supported here
>>>> line 1:68 character '' not supported here
>>>> line 1:69 character '' not supported here
>>>> line 1:70 character '' not supported here
>>>> line 1:71 character '' not supported here
>>>> line 1:72 character '' not supported here
>>>> line 1:73 character '' not supported here
>>>> line 1:74 character '' not supported here
>>>> line 1:75 character '' not supported here
>>>> line 1:76 character '' not supported here
>>>> line 1:77 character '' not supported here
>>>> line 1:78 character '' not supported here
>>>> line 1:79 character '' not supported here
>>>> .
>>>> .
>>>> .
>>>> .
>>>> .
>>>> .
>>>>  line 1:378 character '' not supported here
>>>> line 1:379 character '' not supported here
>>>> line 1:380 character '' not supported here
>>>> line 1:381 character '' not supported here
>>>>
>>>>  Strangely other queries like *select foo from pokes where bar =
>>>> 'tariq';* are working fine. Tried to search over the net but could not
>>>> find anything useful.Need some help.
>>>>
>>>>  Thank you so much for your time.
>>>>
>>>>  Warm Regards,
>>>> Tariq
>>>> cloudfront.blogspot.com
>>>>
>>>
>>>
>>
>> CONFIDENTIALITY NOTICE
>> ======================
>> This email message and any attachments are for the exclusive use of the
>> intended recipient(s) and may contain confidential and privileged
>> information. Any unauthorized review, use, disclosure or distribution is
>> prohibited. If you are not the intended recipient, please contact the
>> sender by reply email and destroy all copies of the original message along
>> with any attachments, from your computer system. If you are the intended
>> recipient, please be advised that the content of this message is subject to
>> access, review and disclosure by the sender's Email System Administrator.
>>
>
>
> CONFIDENTIALITY NOTICE
> ======================
> This email message and any attachments are for the exclusive use of the
> intended recipient(s) and may contain confidential and privileged
> information. Any unauthorized review, use, disclosure or distribution is
> prohibited. If you are not the intended recipient, please contact the
> sender by reply email and destroy all copies of the original message along
> with any attachments, from your computer system. If you are the intended
> recipient, please be advised that the content of this message is subject to
> access, review and disclosure by the sender's Email System Administrator.
>



-- 
Swarnim

Mime
View raw message