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.
--
Oh, never mind. The support of CTAS queries is pretty limited. Can you try
to first create the table and then use insert into?
On Thu, Sep 11, 2014 at 6:45 PM, Yin Huai wrote:
> What is the schema of "table"?
>
> On Thu, Sep 11, 2014 at 4:30 PM, jamborta wrote:
>
>> thanks. this was actually us
What is the schema of "table"?
On Thu, Sep 11, 2014 at 4:30 PM, jamborta wrote:
> 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
> Sen
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.
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" 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 DELIMITED F
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 (1.0.2