You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Cheng Hao (JIRA)" <ji...@apache.org> on 2014/09/03 04:00:54 UTC
[jira] [Commented] (SPARK-3343) Support for CREATE TABLE AS SELECT
that specifies the format
[ https://issues.apache.org/jira/browse/SPARK-3343?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14119187#comment-14119187 ]
Cheng Hao commented on SPARK-3343:
----------------------------------
Actually I was planning to do in after https://github.com/apache/spark/pull/1846 being merged.
> 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: New Feature
> Components: SQL
> 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: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org