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 Threaded View
Hive >> mail # user >> Error in semantic analysis: Unable to fetch table


Copy link to this message
-
Re: Error in semantic analysis: Unable to fetch table
Hi Keith

Can you get anything when you run "show databases" from php?

Chen

On Fri, Oct 19, 2012 at 2:48 AM, Keith Wiley <[EMAIL PROTECTED]> wrote:

> I never needed the -S.  I would just call it with -e, but yeah, that's the
> basic idea.  The output is gathered in the remaining optional arguments to
> exec().
>
> On Oct 18, 2012, at 22:15 , MiaoMiao wrote:
>
> > What php, you are using exec('hive -S -e "select * from some_table"')
> > or something like that in php?
> >
> > On Fri, Oct 19, 2012 at 4:46 AM, Keith Wiley <[EMAIL PROTECTED]>
> wrote:
> >> If I run a select command on the command line with -e it works.  If I
> run the same command inside hive (without -e) it still works...but if I
> exec it with a -e from php (so obviously the apache user), I get "Error in
> semantic analysis: Unable to fetch table [tablename]".  Bear in mind that
> this overall system worked perfectly for weeks.  I haven't modified the
> code or anything.  What did change was I had to reinstall hadoop and hive
> and I'm sure some configuration parameter is not correct now.  I found some
> Google references to this error but no clear-but solutions.
> >>
> >> What does this error mean and how do I fix it?
> >>
> >> Thanks.
>
>
>
> ________________________________________________________________________________
> Keith Wiley     [EMAIL PROTECTED]     keithwiley.com
> music.keithwiley.com
>
> "Luminous beings are we, not this crude matter."
>                                            --  Yoda
>
> ________________________________________________________________________________
>
>
--
Chen Song
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