Re: FAILED: Error in semantic analysis: Unable to fetch table test_table

2013-06-03 Thread Jamal B
is > altering that table column and change it to tinyint. That might be just > enough to trick it since i think the java code is expecting either a 0 or 1 > - not 'false'. > > might be worth a try. > > > On Mon, Jun 3, 2013 at 5:47 PM, Jamal B wrote: > &

Re: FAILED: Error in semantic analysis: Unable to fetch table test_table

2013-06-03 Thread Jamal B
E_ID`) REFERENCES `SERDES` > (`SERDE_ID`) > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | > {code} > > > On Mon, Jun 3, 2013 at 4:57 PM, Jamal B wrote: > >> I gave that a shot, but it didn't work. Could you run a describe table >> to see if it matches this schema

Re: FAILED: Error in semantic analysis: Unable to fetch table test_table

2013-06-03 Thread Jamal B
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 post, but I could really use some help. >> >> I have Hive

FAILED: Error in semantic analysis: Unable to fetch table test_table

2013-06-03 Thread Jamal B
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. However, when I restart the remote metastore, I can no longer query previously created tables. 'show t