Uploaded image for project: 'Spark'
  1. Spark
  2. SPARK-5011

Add support for WITH SERDEPROPERTIES, TBLPROPERTIES in CREATE TEMPORARY TABLE

    XMLWordPrintableJSON

    Details

    • 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
    • Labels:
      None
    • Target Version/s:

      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

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              OopsOutOfMemory OopsOutOfMemory
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 96h
                96h
                Remaining:
                Remaining Estimate - 96h
                96h
                Logged:
                Time Spent - Not Specified
                Not Specified