kaka11chen opened a new issue, #19357:
URL: https://github.com/apache/doris/issues/19357

   ### 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
   
   master
   
   ### What's Wrong?
   
   **q01 in external_table_emr_p2/hive/test_external_github.groovy sometimes an 
error occurs:** 
   
   2023-05-06 12:02:10.943 INFO [suite-thread-1] 
(test_external_github.groovy:512) - catalog external_yandex created
   
   2023-05-06 12:02:10.944 INFO [suite-thread-1] (Suite.groovy:194) - Execute 
sql: switch external_yandex;
   
   2023-05-06 12:02:10.945 INFO [suite-thread-1] 
(test_external_github.groovy:516) - switched to catalog external_yandex
   
   2023-05-06 12:02:10.945 INFO [suite-thread-1] (Suite.groovy:194) - Execute 
sql: use multi_catalog;
   
   2023-05-06 12:02:11.059 INFO [suite-thread-1] 
(test_external_github.groovy:520) - use multi_catalog
   
   2023-05-06 12:02:11.078 INFO [suite-thread-1] 
(test_external_github.groovy:523) - Process format _parquet
   
   2023-05-06 12:02:11.082 INFO [suite-thread-1] (Suite.groovy:465) - Execute 
tag: 01, sql: SELECT /*+SET_VAR(exec_mem_limit=8589934592) */
   
               repo_name,
   
               count() AS prs,
   
               count(distinct actor_login) AS authors
   
           FROM github_events_parquet
   
           WHERE (event_type = 'PullRequestEvent') AND (action = 'opened') AND 
(actor_login IN
   
           (
   
               SELECT actor_login
   
               FROM github_events_parquet
   
               WHERE (event_type = 'PullRequestEvent') AND (action = 'opened') 
AND (repo_name IN ('yandex/ClickHouse', 'ClickHouse/ClickHouse'))
   
           )) AND (lower(repo_name) NOT LIKE '%clickhouse%')
   
           GROUP BY repo_name
   
           ORDER BY authors DESC, prs DESC, length(repo_name) DESC
   
           LIMIT 50
   
   2023-05-06 12:02:14.475 ERROR [suite-thread-1] (ScriptContext.groovy:121) - 
Run test_external_github in 
/mnt/datadisk0/chenqi/doris/regression-test/suites/external_table_emr_p2/hive/test_external_github.groovy
 failed
   
   java.sql.SQLException: errCode = 2, detailMessage = 
(172.21.0.101)[INTERNAL_ERROR]Read parquet file 
/user/hive/github/parquet/part-00004-902bca87-e0f6-4780-af94-c840b41b1213-c000.snappy.parquet
 failed, reason = [INVALID_ARGUMENT]Can't decode parquet physical type 
BYTE_ARRAY to doris logical type Int32
   
   ### What You Expected?
   
   no error occurs.
   
   ### How to Reproduce?
   
   run q01 in external_table_emr_p2/hive/test_external_github.groovy
   
   ### 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

Reply via email to