[SPARK-5011] Add support for WITH SERDEPROPERTIES, TBLPROPERTIES in CREATE TEMPORARY TABLE

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Later
• Affects Version/s: 1.2.1, 1.3.0
• Fix Version/s: 1.2.1
• Component/s: SQL
• Target Version/s: 1.3.0
• Assignee: Unassigned
• Reporter: OopsOutOfMemory
• Created: 30/Dec/14 18:03
• Updated: 16/Jan/15 02:21
• Resolved: 16/Jan/15 02:21

Description

For external datasource integration.
We have two kinds of datasource:
1. File : like avro, json, parquet, etc..
2. Database: like hbase, cassandra etc...

For `File`, there is not too much configurations. Using Options Syntax is ok.
But for Database we usually have many configuration in different levels.

We need to support `WITH SERDEPROPERTIES` and `TBLPROPERTIES` syntax.

Like Hive HBase:
```
CREATE TABLE hbase_table_1(key int, value string)
STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,cf1:val")
TBLPROPERTIES ("hbase.table.name" = "xyz");
```
refer links:
https://cwiki.apache.org/confluence/display/Hive/HBaseIntegration

Issue Links

• links to: [Github] Pull Request #3847 (OopsOutOfMemory)