You are viewing a plain text version of this content. The canonical link for it is here.
Posted to github@arrow.apache.org by GitBox <gi...@apache.org> on 2022/06/16 09:15:56 UTC
[GitHub] [arrow-datafusion] ike560 opened a new issue, #2738: Version 0.6.0 Panic error during SQL execution
ike560 opened a new issue, #2738:
URL: https://github.com/apache/arrow-datafusion/issues/2738
**Describe the bug**
Panic error occurs when executing Join SQL. Refer to the attached jupyter execution result.
Exception: Arrow error: External error: Arrow error: External error: Execution error: Join Error: task 57 panicked
thread 'tokio-runtime-worker' panicked at 'range end index 83 out of range for slice of length 72'.
<img width="1150" alt="datafusion_panicError" src="https://user-images.githubusercontent.com/107613399/174028980-6428234a-db00-46a0-b20b-ecf2fbfb7b19.png">
**Additional context**
In version 0.5.2, No problem with the same SQL.
--
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: github-unsubscribe@arrow.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [arrow-datafusion] comphead commented on issue #2738: Version 0.6.0 Panic error during SQL execution
Posted by GitBox <gi...@apache.org>.
comphead commented on issue #2738:
URL: https://github.com/apache/arrow-datafusion/issues/2738#issuecomment-1178530717
@ike560 it is valid sql. You can group by company, stock_code but still have only company in select. That doesn't make much sense, but it is still valid
--
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: github-unsubscribe@arrow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [arrow-datafusion] ike560 commented on issue #2738: Version 0.6.0 Panic error during SQL execution
Posted by GitBox <gi...@apache.org>.
ike560 commented on issue #2738:
URL: https://github.com/apache/arrow-datafusion/issues/2738#issuecomment-1173358396
Solved!
After modifying the SQL as below, it was OK. **Help. Do you know why this modified SQL is OK?**
Before GROUP BY company
After GROUP BY company, stock_code
```py
sql = '''
SELECT mas.company, SUM(CAST(trading_volume AS INTEGER)/10000000) AS sum_trading_volume FROM (
SELECT stock_code, company FROM stock_master) AS mas
INNER JOIN stock_trading_info
USING (stock_code)
GROUP BY company, stock_code
ORDER BY sum_trading_volume DESC
LIMIT 10
'''
df = ctx.sql(sql)
```
--
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: github-unsubscribe@arrow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [arrow-datafusion] ike560 commented on issue #2738: Version 0.6.0 Panic error during SQL execution
Posted by GitBox <gi...@apache.org>.
ike560 commented on issue #2738:
URL: https://github.com/apache/arrow-datafusion/issues/2738#issuecomment-1173346782
Additional Information
Column (company) value is UTF-8 Japanese string.
In company value is alpha-numeric string, there is no problem with the same SQL.
--
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: github-unsubscribe@arrow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [arrow-datafusion] ike560 closed issue #2738: Version 0.6.0 Panic error during SQL execution
Posted by GitBox <gi...@apache.org>.
ike560 closed issue #2738: Version 0.6.0 Panic error during SQL execution
URL: https://github.com/apache/arrow-datafusion/issues/2738
--
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: github-unsubscribe@arrow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org