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 <kwi...@keithwiley.com> 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 <kwi...@keithwiley.com> > 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 kwi...@keithwiley.com keithwiley.com > music.keithwiley.com > > "Luminous beings are we, not this crude matter." > -- Yoda > > ________________________________________________________________________________ > > -- Chen Song