huangzhengshun opened a new issue, #34943: URL: https://github.com/apache/doris/issues/34943
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues. ### Version 2.1.3 ### What's Wrong? SemanticException java.lang.ClassNotFoundException: 'org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.executeStatement(JDBCStatementImpl.java:133) at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.executeStatement(SQLQueryJob.java:582) at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.lambda$1(SQLQueryJob.java:491) at org.jkiss.dbeaver.model.exec.DBExecUtils.tryExecuteRecover(DBExecUtils.java:189) at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.executeSingleQuery(SQLQueryJob.java:498) at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.extractData(SQLQueryJob.java:934) at org.jkiss.dbeaver.ui.editors.sql.SQLEditor$QueryResultsContainer.readData(SQLEditor.java:3928) at org.jkiss.dbeaver.ui.controls.resultset.ResultSetJobDataRead.lambda$0(ResultSetJobDataRead.java:123) at org.jkiss.dbeaver.model.exec.DBExecUtils.tryExecuteRecover(DBExecUtils.java:189) at org.jkiss.dbeaver.ui.controls.resultset.ResultSetJobDataRead.run(ResultSetJobDataRead.java:121) at org.jkiss.dbeaver.ui.controls.resultset.ResultSetViewer$ResultSetDataPumpJob.run(ResultSetViewer.java:5104) at org.jkiss.dbeaver.model.runtime.AbstractJob.run(AbstractJob.java:105) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:63) Caused by: org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: SemanticException java.lang.ClassNotFoundException: 'org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat at org.apache.hive.jdbc.Utils.verifySuccess(Utils.java:256) at org.apache.hive.jdbc.Utils.verifySuccessWithInfo(Utils.java:242) at org.apache.hive.jdbc.HiveStatement.execute(HiveStatement.java:254) at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.execute(JDBCStatementImpl.java:330) at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.executeStatement(JDBCStatementImpl.java:131) ... 12 more Caused by: org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: SemanticException java.lang.ClassNotFoundException: 'org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat at org.apache.hive.service.cli.operation.Operation.toSQLException(Operation.java:335) at org.apache.hive.service.cli.operation.SQLOperation.prepare(SQLOperation.java:199) at org.apache.hive.service.cli.operation.SQLOperation.runInternal(SQLOperation.java:260) at org.apache.hive.service.cli.operation.Operation.run(Operation.java:247) at org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementInternal(HiveSessionImpl.java:541) at org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementAsync(HiveSessionImpl.java:527) at sun.reflect.GeneratedMethodAccessor48.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.hive.service.cli.session.HiveSessionProxy.invoke(HiveSessionProxy.java:78) at org.apache.hive.service.cli.session.HiveSessionProxy.access$000(HiveSessionProxy.java:36) at org.apache.hive.service.cli.session.HiveSessionProxy$1.run(HiveSessionProxy.java:63) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAs(Subject.java:422) at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1899) ### What You Expected? 通过doris创建hive，能在hive正常查询数据 ### How to Reproduce? 通过doris创建hive表后，在doris中能正常查询数据，通过获取表结构，其中OutputFormat属性中出现''，导致在hive中查询数据报错。 --创建后doris表结构 CREATE TABLE `doris_test_v5`( `account_book` string COMMENT '', `voucher_no` string COMMENT '', `item_no` string COMMENT '', `voucher_type` string COMMENT '', `account_no` string COMMENT '', `subject_illustration` string COMMENT '', `supplier_code` string COMMENT '', `supplier_name` string COMMENT '', `posting_code` string COMMENT '', `special_gl_id` string COMMENT '', `voucher_date` string COMMENT '', `voucher_abstract` string COMMENT '', `currency_code` string COMMENT '', `original_amount` string COMMENT '', `exchange_rate` string COMMENT '', `equivalent_amount` string COMMENT '', `quantity` string COMMENT '', `unit` string COMMENT '', `project_code` string COMMENT '', `project_name` string COMMENT '', `hirain1001` string COMMENT '', `cost_center` string COMMENT '', `assigner_name` string COMMENT '', `profit_center_code` string COMMENT '', `profit_center` string COMMENT '', `quality_cost` string COMMENT '', `document_no` string COMMENT '', `payment_terms` string COMMENT '', `document_date` string COMMENT '', `document_due_date` string COMMENT '', `account_date` string COMMENT '', `voucher_head_text` string COMMENT '', `the_factory` string COMMENT '', `movement_type` string COMMENT '', `material_document` string COMMENT '', `material_type` string COMMENT '', `transaction_code` string COMMENT '', `material_document_year` string COMMENT '', `storage_location` string COMMENT '', `the_batch` string COMMENT '', `purchase_type` string COMMENT '', `special_procurement` string COMMENT '') COMMENT '' 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://slave2:7000/hive_data/D5D7ECADA9FF46AD9B4F695AE9FB39D3/41885DC9A4CE4BACA7212123C56F0DE3/615305DE04F749EA82AA1513CD4C28BD/doris_test_v5' TBLPROPERTIES ( 'doris.location'='hdfs://slave2:7000/hive_data/D5D7ECADA9FF46AD9B4F695AE9FB39D3/41885DC9A4CE4BACA7212123C56F0DE3/615305DE04F749EA82AA1513CD4C28BD/doris_test_v5', 'outputformat'='org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat', 'transient_lastDdlTime'='1715825319', 'parquet.compression'='snappy', 'doris.version'='doris-2.1.3-rc06-e9f5388541', 'doris.file_format'='parquet'); --创建后hive表结构 CREATE TABLE `doris_test_v5`( `account_book` string COMMENT '', `voucher_no` string COMMENT '', `item_no` string COMMENT '', `voucher_type` string COMMENT '', `account_no` string COMMENT '', `subject_illustration` string COMMENT '', `supplier_code` string COMMENT '', `supplier_name` string COMMENT '', `posting_code` string COMMENT '', `special_gl_id` string COMMENT '', `voucher_date` string COMMENT '', `voucher_abstract` string COMMENT '', `currency_code` string COMMENT '', `original_amount` string COMMENT '', `exchange_rate` string COMMENT '', `equivalent_amount` string COMMENT '', `quantity` string COMMENT '', `unit` string COMMENT '', `project_code` string COMMENT '', `project_name` string COMMENT '', `hirain1001` string COMMENT '', `cost_center` string COMMENT '', `assigner_name` string COMMENT '', `profit_center_code` string COMMENT '', `profit_center` string COMMENT '', `quality_cost` string COMMENT '', `document_no` string COMMENT '', `payment_terms` string COMMENT '', `document_date` string COMMENT '', `document_due_date` string COMMENT '', `account_date` string COMMENT '', `voucher_head_text` string COMMENT '', `the_factory` string COMMENT '', `movement_type` string COMMENT '', `material_document` string COMMENT '', `material_type` string COMMENT '', `transaction_code` string COMMENT '', `material_document_year` string COMMENT '', `storage_location` string COMMENT '', `the_batch` string COMMENT '', `purchase_type` string COMMENT '', `special_procurement` string COMMENT '') COMMENT '' 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://slave2:7000/hive_data/D5D7ECADA9FF46AD9B4F695AE9FB39D3/41885DC9A4CE4BACA7212123C56F0DE3/615305DE04F749EA82AA1513CD4C28BD/doris_test_v5' TBLPROPERTIES ( 'doris.file_format'='parquet', 'doris.location'='hdfs://slave2:7000/hive_data/D5D7ECADA9FF46AD9B4F695AE9FB39D3/41885DC9A4CE4BACA7212123C56F0DE3/615305DE04F749EA82AA1513CD4C28BD/doris_test_v5', 'doris.version'='doris-2.1.3-rc06-e9f5388541', 'outputformat'='org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat', 'parquet.compression'='snappy', 'transient_lastDdlTime'='1715825319') ### Anything Else? _No response_ ### Are you willing to submit PR? - [X] Yes I am willing to submit a PR! ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
