This should work
Spark 2.0.0, Hive 2.0.1
//create external table in a Hive database with CTAS
scala> spark.sql(""" CREATE EXTERNAL TABLE test.extPrices LOCATION
"/tmp/extPrices" AS SELECT * FROM test.prices LIMIT 5""")
res4: org.apache.spark.sql.DataFrame = []
Now if I go to Hive and look at
Hi All,
I am facing different problem using spark,
i am using spark-sql.
below are the details,
sqlcontext.sql("""create external table location '/' as select *
from XXX""" )
this is my query
table success fully done but in hive command
describe formatted
showing MANAGETABLE,