spark-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Michael Armbrust (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (SPARK-5591) NoSuchObjectException for CTAS
Date Wed, 04 Feb 2015 22:34:35 GMT

     [ https://issues.apache.org/jira/browse/SPARK-5591?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Michael Armbrust resolved SPARK-5591.
-------------------------------------
       Resolution: Fixed
    Fix Version/s: 1.3.0

Issue resolved by pull request 4365
[https://github.com/apache/spark/pull/4365]

> NoSuchObjectException for CTAS
> ------------------------------
>
>                 Key: SPARK-5591
>                 URL: https://issues.apache.org/jira/browse/SPARK-5591
>             Project: Spark
>          Issue Type: Improvement
>          Components: SQL
>    Affects Versions: 1.2.0
>            Reporter: wangfei
>             Fix For: 1.3.0
>
>
> NoSuchObjectException for CTAS, 
> create table sc as select * 
> from (select '2011-01-11', '2011-01-11+14:18:26' from src tablesample (1 rows)
>       union all 
>       select '2011-01-11', '2011-01-11+15:18:26' from src tablesample (1 rows)
>       union all 
>       select '2011-01-11', '2011-01-11+16:18:26' from src tablesample (1 rows) ) s;
> Get this exception:
> 15/02/04 19:44:02 ERROR Hive: NoSuchObjectException(message:default.sc table not found)
>         at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.get_table(HiveMetaStore.java:1560)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
>         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>         at java.lang.reflect.Method.invoke(Method.java:601)
>         at org.apache.hadoop.hive.metastore.RetryingHMSHandler.invoke(RetryingHMSHandler.java:105)
>         at $Proxy8.get_table(Unknown Source)
>         at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getTable(HiveMetaStoreClient.java:997)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
>         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>         at java.lang.reflect.Method.invoke(Method.java:601)
>         at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.invoke(RetryingMetaStoreClient.java:89)
>         at $Proxy9.getTable(Unknown Source)
>         at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:976)
>         at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:950)
>         at org.apache.spark.sql.hive.HiveMetastoreCatalog.tableExists(HiveMetastoreCatalog.scala:152)
>         at org.apache.spark.sql.hive.HiveContext$$anon$2.org$apache$spark$sql$catalyst$analysis$OverrideCatalog$$super$tableExists(HiveContext.scala:309)
>         at org.apache.spark.sql.catalyst.analysis.OverrideCatalog$class.tableExists(Catalog.scala:121)
>         at org.apache.spark.sql.hive.HiveContext$$anon$2.tableExists(HiveContext.scala:309)
>         at org.apache.spark.sql.hive.execution.CreateTableAsSelect.run(CreateTableAsSelect.scala:63)
>         at org.apache.spark.sql.execution.ExecutedCommand.sideEffectResult$lzycompute(commands.scala:53)



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org


Mime
View raw message