joice1910 opened a new issue, #25330: URL: https://github.com/apache/doris/issues/25330
### 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 Doris Version: 2.0.1.1 Hive Version: 3.1.3 Distribution : CDP Cluster Security: Kerberized ### What's Wrong? I wanted to report a bug that I've encountered while executing the query "select * from instantcdr limit 10;". The error message I received is as follows: ``` select * from instantcdr limit 10; ERROR 1105 (HY000): errCode = 2, detailMessage = (10.128.0.4)[CANCELLED][INTERNAL_ERROR]Failed to create orc row reader. reason = I nvalid column selected row.rowId. Valid names are bucket, currentTransaction, operation, originalTransaction, row, [row.ac](http://row.ac/)_type, row .channel, row.data_amt, row.date_id, row.field1, row.field10, row.field11, row.field12, row.field13, row.field14, row.field15, row. field16, row.field17, row.field18, row.field19, row.field2, row.field20, row.field3, row.field4, row.field5, row.field6, row.field7 , row.f ``` As part of my report, I have attached the table script and relevant screenshots to provide further context and details related to this issue. `CREATE TABLE `instantcdr`( `rowid` int, `msisdn` varchar(12), `date_id` int, `channel` varchar(8), `usage_type` varchar(6), `ac_type` varchar(10), `voice_amt` int, `sms_amt` int, `data_amt` int, `field1` varchar(20), `field2` varchar(20), `field3` varchar(20), `field4` varchar(20), `field5` varchar(20), `field6` varchar(20), `field7` varchar(20), `field8` varchar(20), `field9` varchar(20), `field10` varchar(20), `field11` varchar(20), `field12` varchar(20), `field13` varchar(20), `field14` varchar(20), `field15` varchar(20), `field16` varchar(20), `field17` varchar(20), `field18` varchar(20), `field19` varchar(20), `field20` varchar(20), `s_date` date) PARTITIONED BY ( `date_idp` int) ROW FORMAT SERDE '[org.apache.hadoop.hive.ql.io](http://org.apache.hadoop.hive.ql.io/).orc.OrcSerde' STORED AS INPUTFORMAT '[org.apache.hadoop.hive.ql.io](http://org.apache.hadoop.hive.ql.io/).orc.OrcInputFormat' OUTPUTFORMAT '[org.apache.hadoop.hive.ql.io](http://org.apache.hadoop.hive.ql.io/).orc.OrcOutputFormat' LOCATION 'hdfs://instance-3:8020/warehouse/tablespace/managed/hive/instantcdr' TBLPROPERTIES ( 'transient_lastDdlTime'='1696942303', 'orc.compress'='snappy', 'bucketing_version'='2', 'transactional_properties'='default', 'transactional'='true')`  ### What You Expected? I would appreciate it if you could take a look at this bug report and investigate the problem further. Your assistance in resolving this issue would be greatly valued. ### How to Reproduce? _No response_ ### Anything Else? It appears that the discrepancy between the "rowid" in the ORC schema and the "rowid" in my table schema was indeed the root cause of the problem.  ### Are you willing to submit PR? - [ ] 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
