spark-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Aley <james.a...@swiftkey.com>
Subject [Spark SQL] Problems creating a table in specified schema/database
Date Tue, 28 Apr 2015 08:54:23 GMT
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.

Mime
View raw message