[
https://issues.apache.org/jira/browse/SPARK-3343?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Michael Armbrust updated SPARK-3343:
------------------------------------
Summary: Support for CREATE TABLE AS SELECT that specifies the format
(was: Unsupported language features in query)
> Support for CREATE TABLE AS SELECT that specifies the format
> ------------------------------------------------------------
>
> Key: SPARK-3343
> URL: https://issues.apache.org/jira/browse/SPARK-3343
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 1.0.2
> Reporter: HuQizhong
>
> hql("""CREATE TABLE tmp_adclick_gm_all ROW FORMAT DELIMITED FIELDS
> TERMINATED BY ',' LINES TERMINATED BY '\n' as SELECT SUM(uv) as uv,
> round(SUM(cost),2) as total, round(SUM(cost)/SUM(uv),2) FROM
> tmp_adclick_sellplat """)
> 14/09/02 15:32:28 INFO ParseDriver: Parse Completed
> java.lang.RuntimeException:
> Unsupported language features in query: CREATE TABLE
> tmp_adclick_gm_all ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' LINES
> TERMINATED BY 'abc' as SELECT SUM(uv) as uv, round(SUM(cost),2) as
> total, round(SUM(cost)/SUM(uv),2) FROM tmp_adclick_sellplat
> at scala.sys.package$.error(package.scala:27)
> at org.apache.spark.sql.hive.HiveQl$.parseSql(HiveQl.scala:255)
> at org.apache.spark.sql.hive.HiveContext.hiveql(HiveContext.scala:75)
> at org.apache.spark.sql.hive.HiveContext.hql(HiveContext.scala:78)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
