You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Xiao Li (JIRA)" <ji...@apache.org> on 2016/06/25 23:09:37 UTC
[jira] [Updated] (SPARK-16185) Unresolved Operator When Creating
Table As Select Without Enabling Hive Support
[ https://issues.apache.org/jira/browse/SPARK-16185?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Xiao Li updated SPARK-16185:
----------------------------
Description:
When we do not turn on the Hive Support, the following query generates a confusing error message:
{noformat}
sql("CREATE TABLE t2 SELECT a, b from t1")
{noformat}
{noformat}
unresolved operator 'CreateHiveTableAsSelectLogicalPlan CatalogTable(
Table: `t`
Created: Fri Jun 24 00:09:15 PDT 2016
Last Access: Wed Dec 31 15:59:59 PST 1969
Type: MANAGED
Storage(InputFormat: org.apache.hadoop.mapred.TextInputFormat, OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat)), false;
org.apache.spark.sql.AnalysisException: unresolved operator 'CreateHiveTableAsSelectLogicalPlan CatalogTable(
Table: `t`
Created: Fri Jun 24 00:09:15 PDT 2016
Last Access: Wed Dec 31 15:59:59 PST 1969
Type: MANAGED
Storage(InputFormat: org.apache.hadoop.mapred.TextInputFormat, OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat)), false;
{noformat}
was:
When we do not turn on the Hive Support, the following query generates a confusing error message:
{noformat}
sql("CREATE TABLE t2 USING parquet SELECT a, b from t1")
{noformat}
{noformat}
unresolved operator 'CreateHiveTableAsSelectLogicalPlan CatalogTable(
Table: `t`
Created: Fri Jun 24 00:09:15 PDT 2016
Last Access: Wed Dec 31 15:59:59 PST 1969
Type: MANAGED
Storage(InputFormat: org.apache.hadoop.mapred.TextInputFormat, OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat)), false;
org.apache.spark.sql.AnalysisException: unresolved operator 'CreateHiveTableAsSelectLogicalPlan CatalogTable(
Table: `t`
Created: Fri Jun 24 00:09:15 PDT 2016
Last Access: Wed Dec 31 15:59:59 PST 1969
Type: MANAGED
Storage(InputFormat: org.apache.hadoop.mapred.TextInputFormat, OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat)), false;
{noformat}
> Unresolved Operator When Creating Table As Select Without Enabling Hive Support
> -------------------------------------------------------------------------------
>
> Key: SPARK-16185
> URL: https://issues.apache.org/jira/browse/SPARK-16185
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 2.0.0
> Reporter: Xiao Li
>
> When we do not turn on the Hive Support, the following query generates a confusing error message:
> {noformat}
> sql("CREATE TABLE t2 SELECT a, b from t1")
> {noformat}
> {noformat}
> unresolved operator 'CreateHiveTableAsSelectLogicalPlan CatalogTable(
> Table: `t`
> Created: Fri Jun 24 00:09:15 PDT 2016
> Last Access: Wed Dec 31 15:59:59 PST 1969
> Type: MANAGED
> Storage(InputFormat: org.apache.hadoop.mapred.TextInputFormat, OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat)), false;
> org.apache.spark.sql.AnalysisException: unresolved operator 'CreateHiveTableAsSelectLogicalPlan CatalogTable(
> Table: `t`
> Created: Fri Jun 24 00:09:15 PDT 2016
> Last Access: Wed Dec 31 15:59:59 PST 1969
> Type: MANAGED
> Storage(InputFormat: org.apache.hadoop.mapred.TextInputFormat, OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat)), false;
> {noformat}
--
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