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
+
Mohammad Tariq 2013-06-20, 01:59
+
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
Copy link to this message
-
Re: "show table" throwing strange error
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 <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>>
Reply-To: "[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>" <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>>
Date: Thursday, June 20, 2013 12:52 PM
To: user <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>>
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<http://cloudfront.blogspot.com>
On Fri, Jun 21, 2013 at 1:03 AM, Sanjay Subramanian <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>> wrote:
Can u try from your ubuntu command prompt
$> hive -e "show tables"

From: Mohammad Tariq <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>>
Reply-To: "[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>" <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>>
Date: Thursday, June 20, 2013 4:28 AM
To: user <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>>

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<http://cloudfront.blogspot.com>
On Thu, Jun 20, 2013 at 8:43 AM, Sunita Arvind <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>> 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 <[EMAIL PROTECTED]<mailto:[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 :

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
+
kulkarni.swarnim@...) 2013-06-21, 20:56
+
shashwat shriparv 2013-06-22, 09:58
+
Mohammad Tariq 2013-07-01, 02:43