Hi,
How can i create a table using spark SQL?
I try the query
CREATE TEMPORARY TABLE plugUsage
USING CarbonAnalytics
OPTIONS (tableName "plug_usage",
schema "house_id INT, household_id INT, plug_id INT, usage FLOAT
-sp,
primaryKeys "household_id, plug_id"
);
But give me following error,
*ERROR: *[1.1] failure: ``insert'' expected but identifier CREATE found
CREATE TEMPORARY TABLE X1234_plugUsage ^
Thanks and Regards.
--
Rukshan Chathuranga.
Software Engineer.
WSO2, Inc.
_______________________________________________
Dev mailing list
[email protected]
http://wso2.org/cgi-bin/mailman/listinfo/dev
