>>>> | 2 | |
>>>>> | 6 | |
>>>>> |11 | |
>>>>> |26 | |
>>>>> |31 | |
>>>>> | 36 | |
>>>>> |
;>> |41 | |
>>>> |46 | |
>>>> |47 | |
>>>> +---+---+
>>>> 10 rows in set (0.00 sec)
>>>> {code}
>>>>
>>>> so *maybe* that 'false&#
ckend store? might you experiment and change it to a null string? and
>>> see if that changes anything? Something to think about anyway.
>>>
>>>
>>>
>>> On Mon, Jun 3, 2013 at 12:49 PM, Jamal B wrote:
>>>
>>>> Please forgive the cross
un 3, 2013 at 12:49 PM, Jamal B wrote:
>>
>>> Please forgive the cross post, but I could really use some help.
>>>
>>> I have Hive setup using a remote metastore, backed by H2, and am able to
>>> create tables, load data, and query them without issue. Howev
setup using a remote metastore, backed by H2, and am able to
>> create tables, load data, and query them without issue. However, when I
>> restart the remote metastore, I can no longer query previously created
>> tables. 'show tables' shows them, but when I perform a simple se
iously created
> tables. 'show tables' shows them, but when I perform a simple select
> 'select * from test_table limit 5' I receive a FAILED: Error in semantic
> analysis: Unable to fetch table test_table error. When I look at the logs
> in the metastore, I notic
;show tables' shows them, but when I perform a simple select
'select * from test_table limit 5' I receive a FAILED: Error in semantic
analysis: Unable to fetch table test_table error. When I look at the logs
in the metastore, I noticed the following exceptions repeat until the ret
> >> 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 [ta
rom 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 reinst
t -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 an
Followup: If I run "show tables" then while I get a list from the command line,
I get nothing from php. Furthermore, if I attempt to select from a bogus
tablename on the command line, I get that same error, "semantic error" and
whatnot...so it looks like the real problem is that when apache/php
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
12 matches
Mail list logo
