使用 Spark 驱动程序在 Databricks 中创建 Hive 表（数据文件格式 = AVRO）

Question

TableQuery：

CREATE  TABLE `zdp`.`asdasdEntity_1` (`ter` string COMMENT 'system generated')  
 ROW FORMAT  SERDE 'org.apache.hadoop.hive.serde2.avro.AvroSerDe' 
    STORED AS  
        INPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerInputFormat' 
        OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerOutputFormat'

输出：

1. 表是在 databricks 中创建的，
2. 无法使用（desc 扩展表名）描述表属性，给出以下输出：

error_error_error_error_error_error_error
string
from deserializer
cannot_determine_schema
string
from deserializer
check
string
from deserializer
schema
string
from deserializer
url
string
from deserializer
and
string
from deserializer
literal
string
from deserializer

Answer 1

CREATE TABLE avroExample
ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.avro.AvroSerDe'
STORED AS INPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerInputFormat'
    OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerOutputFormat'
TBLPROPERTIES ('avro.schema.literal'='{ "namespace": "org.apache.hive",
    "name": "first_schema",
    "type": "record",
    "fields": [
            { "name":"string1", "type":"string" },
            { "name":"string2", "type":"string" }
        ] }');