No, sorry this is not supported. Support for more than one database is lacking in several areas (though mostly works for hive tables). I'd like to fix this in Spark 1.5.
On Tue, Apr 28, 2015 at 1:54 AM, James Aley <[email protected]> wrote: > Hey all, > > I'm trying to create tables from existing Parquet data in different > schemata. The following isn't working for me: > > CREATE DATABASE foo; > > CREATE TABLE foo.bar > USING com.databricks.spark.avro > OPTIONS (path '...'); > > -- Error: org.apache.spark.sql.AnalysisException: cannot recognize input > near 'USING' 'com' '.' in table name; line 1 pos 13 (state=,code=0) > > I also tried.... > > USE foo; > CREATE TABLE bar > USING com.databricks.spark.avro > OPTIONS (path '...'); > > -- Creates the table successfully, but in the default.* schema. > > > This is on Spark 1.3.1, running on YARN, Hive 0.13.1. Any suggestions? > Should this work? > > > James. >
