We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
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
Hive table:
CREATE TABLE `hive_temp.demo`( `trace_id` string COMMENT 'from deserializer', `loan_account_id` string COMMENT 'from deserializer', `name` string COMMENT 'from deserializer', `mobile_number` string COMMENT 'from deserializer', `identity_number` string COMMENT 'from deserializer', `status_desc` string COMMENT 'from deserializer', `status` string COMMENT 'from deserializer', `status_json` string COMMENT 'from deserializer') ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.OpenCSVSerde' WITH SERDEPROPERTIES ( 'escapeChar'='\\', 'quoteChar'='"', 'separatorChar'=',') STORED AS INPUTFORMAT 'org.apache.hadoop.mapred.TextInputFormat' OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' LOCATION 'hdfs://yqgcluster/user/hive/warehouse/risk_temp.db/demo' TBLPROPERTIES ( 'bucketing_version'='2', 'skip.header.line.count'='1', 'transient_lastDdlTime'='1744266420')
The JSON field status_jsons value can be read successfully by starrocks
status_json
The JSON field status_jsons value is delimited by , separator while reading by starrocks
,
The text was updated successfully, but these errors were encountered:
No branches or pull requests
Steps to reproduce the behavior (Required)
Hive table:
Expected behavior (Required)
The JSON field
status_json
s value can be read successfully by starrocksReal behavior (Required)
The JSON field
status_json
s value is delimited by,
separator while reading by starrocksStarRocks version (Required)
The text was updated successfully, but these errors were encountered: