'STORED AS INPUTFORMAT', 'OUTPUTFORMAT', and 'ROW FORMAT SERDE' is not supported
kukigai opened this issue · 2 comments
Describe the bug
'STORED AS INPUTFORMAT' and 'OUTPUTFORMAT' is not supported
To Reproduce
ddl = """
CREATE EXTERNAL TABLE test (
test STRING NULL COMMENT 'xxxx',
)
ROW FORMAT SERDE
'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'
STORED AS INPUTFORMAT
'org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat'
OUTPUTFORMAT
'org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat'
LOCATION
'hdfs://xxxx'
"""
Expected behavior
non empty response
ROW FORMAT SERDE - supported, if you will try CREATE EXTERNAL TABLE test ( test STRING NULL COMMENT 'xxxx', ) ROW FORMAT SERDE 'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'
you will got the result, but OUTPUTFORMAT & STORED AS INPUTFORMAT - not, I will add them
@kukigai, support added in 0.19.7 (already released), test here - https://github.com/xnuinside/simple-ddl-parser/blob/main/tests/test_hql_output_mode.py#L1769