Hi Nan, It is basically a log entry because your table does not exist. It is not a real exception.
Thanks, Yin On Mon, Jul 21, 2014 at 7:10 AM, Nan Zhu <zhunanmcg...@gmail.com> wrote: > a related JIRA: https://issues.apache.org/jira/browse/SPARK-2605 > > -- > Nan Zhu > > On Monday, July 21, 2014 at 10:10 AM, Nan Zhu wrote: > > Hi, all > > When I try hiveContext.hql("drop table if exists abc") where abc is a > non-exist table > > I still received an exception about non-exist table though "if exists" is > there > > the same statement runs well in hive shell > > Some feedback from Hive community is here: > https://issues.apache.org/jira/browse/HIVE-7458 > > “Your are doing hiveContext.hql("DROP TABLE IF EXISTS hivetesting") in > Scala schell of the Spark project. > > What this shell is doing ? Query to remote metastore on non existing table > (see on your provided stack). > The remote metastore throws NoSuchObjectException(message:default.hivetesting > table not found)because Spark code call > HiveMetaStoreClient.getTable(HiveMetaStoreClient.java:854) on > non-existing table. It's the right behavior. > You should check on Spark code why a query is done on non existing table. > > I think Spark does not handle well the IF EXISTS part of this query. > Maybe you could fill a ticket on Spark JIRA. > BUT, it's *not a bug* in HIVE IMHO.” > > My question is the DDL is executed by Hive itself, doesn’t it? > > Best, > > -- > Nan Zhu > > >
