[
https://issues.apache.org/jira/browse/IMPALA-13284?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17871898#comment-17871898
]
Quanlong Huang commented on IMPALA-13284:
-----------------------------------------
Another error is "STORED AS JSONFILE" is not supported in Apache Hive3
(HIVE-19899).
{code:sql}
CREATE TABLE IF NOT EXISTS functional_json_snap.bucketed_table (
col1 int, col2 int)
CLUSTERED BY (col1) INTO 5 BUCKETS
STORED AS JSONFILE;
Error: Error while compiling statement: FAILED: SemanticException Unrecognized
file format in STORED AS clause: 'JSONFILE' (state=42000,code=40000){code}
Need to explicitly set the serde library:
{code:sql}
CREATE TABLE IF NOT EXISTS functional_json_snap.bucketed_table (
col1 int, col2 int)
CLUSTERED BY (col1) INTO 5 BUCKETS
ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.JsonSerDe';{code}
> Loading test data on Apache Hive3
> ---------------------------------
>
> Key: IMPALA-13284
> URL: https://issues.apache.org/jira/browse/IMPALA-13284
> Project: IMPALA
> Issue Type: Task
> Components: Infrastructure
> Reporter: Quanlong Huang
> Assignee: Quanlong Huang
> Priority: Major
>
> When building on Apache Hive3, there are some failures in loading test data,
> e.g.
> {noformat}
> ERROR: ALTER TABLE functional_parquet.iceberg_lineitem_sixblocks CONVERT TO
> ICEBERG
> Traceback (most recent call last):
> File "/media/quanlong/hdd-backup/impala-apache-hive/bin/load-data.py", line
> 195, in exec_impala_query_from_file
> result = impala_client.execute(query)
> File
> "/media/quanlong/hdd-backup/impala-apache-hive/tests/beeswax/impala_beeswax.py",
> line 191, in execute
> handle = self.__execute_query(query_string.strip(), user=user)
> File
> "/media/quanlong/hdd-backup/impala-apache-hive/tests/beeswax/impala_beeswax.py",
> line 382, in __execute_query
> handle = self.execute_query_async(query_string, user=user)
> File
> "/media/quanlong/hdd-backup/impala-apache-hive/tests/beeswax/impala_beeswax.py",
> line 376, in execute_query_async
> handle = self.__do_rpc(lambda: self.imp_service.query(query,))
> File
> "/media/quanlong/hdd-backup/impala-apache-hive/tests/beeswax/impala_beeswax.py",
> line 539, in __do_rpc
> raise ImpalaBeeswaxException(self.__build_error_message(b), b)
> ImpalaBeeswaxException: ImpalaBeeswaxException:
> INNER EXCEPTION: <class 'beeswaxd.ttypes.BeeswaxException'>
> MESSAGE: AnalysisException: CONVERT TO ICEBERG is not supported for managed
> tables{noformat}
> This is due to the table is created as a managed table in Hive.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
