thanks. I will try to do that way.
--
View this message in context:
http://apache-spark-user-list.1001560.n3.nabble.com/spark-sql-create-new-table-as-select-from-table-tp14006p14090.html
Sent from the Apache Spark User List mailing list archive at Nabble.com.
Hi,
I am trying to create a new table from a select query as follows:
CREATE TABLE IF NOT EXISTS new_table ROW FORMAT DELIMITED FIELDS TERMINATED
BY ',' LINES TERMINATED BY '\n' STORED AS TEXTFILE LOCATION
'/user/test/new_table' AS select * from table
this works in Hive, but in Spark SQL
The implementation of SparkSQL is currently incomplete. You may try it out
with HiveContext instead of SQLContext.
On 9/11/14, 1:21 PM, jamborta jambo...@gmail.com wrote:
Hi,
I am trying to create a new table from a select query as follows:
CREATE TABLE IF NOT EXISTS new_table ROW FORMAT
thanks. this was actually using hivecontext.
--
View this message in context:
http://apache-spark-user-list.1001560.n3.nabble.com/spark-sql-create-new-table-as-select-from-table-tp14006p14009.html
Sent from the Apache Spark User List mailing list archive at Nabble.com.
What is the schema of table?
On Thu, Sep 11, 2014 at 4:30 PM, jamborta jambo...@gmail.com wrote:
thanks. this was actually using hivecontext.
--
View this message in context: