Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

'STORED AS INPUTFORMAT', 'OUTPUTFORMAT', and 'ROW FORMAT SERDE' is not supported #69

Closed
kukigai opened this issue Sep 18, 2021 · 2 comments

Comments

@kukigai
Copy link

kukigai commented Sep 18, 2021

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

@kukigai kukigai changed the title 'STORED AS INPUTFORMAT' and 'OUTPUTFORMAT' is not supported 'STORED AS INPUTFORMAT', 'OUTPUTFORMAT', and 'ROW FORMAT SERDE' is not supported Sep 18, 2021
@xnuinside
Copy link
Owner

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

@xnuinside
Copy link
Owner

@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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants