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

Add support for WITH SERDEPROPERTIES, TBLPROPERTIES in CREATE TEMPORARY TABLE

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Minor
    • Resolution: Later
    • 1.2.1, 1.3.0
    • 1.2.1
    • SQL
    • None

    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

            Unassigned Unassigned
            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