You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "dutyu (via GitHub)" <gi...@apache.org> on 2023/05/26 04:02:13 UTC
[GitHub] [doris] dutyu opened a new issue, #20088: [Bug] Stmt execute failed when submit a query with hive external tbl
dutyu opened a new issue, #20088:
URL: https://github.com/apache/doris/issues/20088
### 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
1.2.4
### What's Wrong?
SQL:
```sql
select
t_1.y_all_nums,
t_2.by_all_nums,
(t_1.y_all_nums - t_2.by_all_nums)* 100 / t_2.by_all_nums as n1
from
(
SELECT
'editlog_info' as name,
count(1) as y_all_nums
from
dp_data_db.editlog_info
where
pday = '20230416'
) t_1
left outer join (
select
'editlog_info' as name,
count(1) as by_all_nums
from
dp_data_db.editlog_info
where
pday = '20230415'
) t_2 on t_1.name = t_2.name
LIMIT
1000
```
Error message: `detailMessage = Fail to parse columnsFromPath, expected: [pday], filePath: hdfs://xxx/auditlog/output/20230416/part-00000`
This table is a hive external table, the tbl creater defines the source data path as `hdfs://xxx/auditlog/output/${pay}`, it does not match the "hdfs://xxx/../partition-key=partition-value" format.
### What You Expected?
Query should not fail.
### How to Reproduce?
_No response_
### Anything Else?
_No response_
### 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-unsubscribe@doris.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [doris] dutyu commented on issue #20088: [Bug] Stmt execute failed when submit a query with hive external tbl
Posted by "dutyu (via GitHub)" <gi...@apache.org>.
dutyu commented on issue #20088:
URL: https://github.com/apache/doris/issues/20088#issuecomment-1563907518
> Is Hive Catalog?
Yeah, use hive catalog, and this issue may have been fixed in master branch, is it right?
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [doris] dutyu closed issue #20088: [Bug] Stmt execute failed when submit a query with hive external tbl
Posted by "dutyu (via GitHub)" <gi...@apache.org>.
dutyu closed issue #20088: [Bug] Stmt execute failed when submit a query with hive external tbl
URL: https://github.com/apache/doris/issues/20088
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [doris] LemonLiTree commented on issue #20088: [Bug] Stmt execute failed when submit a query with hive external tbl
Posted by "LemonLiTree (via GitHub)" <gi...@apache.org>.
LemonLiTree commented on issue #20088:
URL: https://github.com/apache/doris/issues/20088#issuecomment-1563879486
Is Hive Catalog?
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [doris] dutyu commented on issue #20088: [Bug] Stmt execute failed when submit a query with hive external tbl
Posted by "dutyu (via GitHub)" <gi...@apache.org>.
dutyu commented on issue #20088:
URL: https://github.com/apache/doris/issues/20088#issuecomment-1571737074
> it is fixed in master
Got it~
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [doris] Yulei-Yang commented on issue #20088: [Bug] Stmt execute failed when submit a query with hive external tbl
Posted by "Yulei-Yang (via GitHub)" <gi...@apache.org>.
Yulei-Yang commented on issue #20088:
URL: https://github.com/apache/doris/issues/20088#issuecomment-1571688220
it is fixed in master
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org