[Spark SQL] Problems creating a table in specified schema/database

[James Aley]

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.