NGA-TRAN opened a new issue #821:
URL: https://github.com/apache/arrow-datafusion/issues/821
**Describe the bug**
while running the below SQL, I this this internal error
`Error running remote query: status: Internal, message: "Internal error
reading points from database 844910ece80be8bc_3c0bd4c89186ca89: Internal error
executing plan: Arrow error: External error: Arrow error: External error: Arrow
error: External error: Execution error: Internal error: Unsupported data type
in hasher. This was likely caused by a bug in DataFusion's code and we would
welcome that you file an bug report in our issue tracker", details: [],
metadata: MetadataMap { headers: {"content-type": "application/grpc", "date":
"Tue, 03 Aug 2021 18:55:08 GMT"} }`
**To Reproduce**
SQL:
SELECT Row_number()
OVER (
partition BY Date_trunc('minute', time), bucket_id, partition_id
ORDER BY time DESC) AS rn,
gauge,
Date_trunc('minute', time) AS time_bucket,
env
FROM storage_usage_bucket_cardinality
WHERE Cast(time AS BIGINT) > Cast(Now() AS BIGINT) - 5 * 60 * 1000000000
AND time <= Now();
Description of table `storage_usage_bucket_cardinality`
+---------------+--------------+----------------------------------+--------------+-----------------------------+-------------+
| table_catalog | table_schema | table_name |
column_name | data_type | is_nullable |
+---------------+--------------+----------------------------------+--------------+-----------------------------+-------------+
| public | iox | storage_usage_bucket_cardinality |
bucket_id | Dictionary(Int32, Utf8) | YES |
| public | iox | storage_usage_bucket_cardinality | env
| Dictionary(Int32, Utf8) | YES |
| public | iox | storage_usage_bucket_cardinality | gauge
| Float64 | YES |
| public | iox | storage_usage_bucket_cardinality | host
| Dictionary(Int32, Utf8) | YES |
| public | iox | storage_usage_bucket_cardinality | hostname
| Dictionary(Int32, Utf8) | YES |
| public | iox | storage_usage_bucket_cardinality | node_id
| Dictionary(Int32, Utf8) | YES |
| public | iox | storage_usage_bucket_cardinality | nodename
| Dictionary(Int32, Utf8) | YES |
| public | iox | storage_usage_bucket_cardinality | org_id
| Dictionary(Int32, Utf8) | YES |
| public | iox | storage_usage_bucket_cardinality |
partition_id | Dictionary(Int32, Utf8) | YES |
| public | iox | storage_usage_bucket_cardinality | role
| Dictionary(Int32, Utf8) | YES |
| public | iox | storage_usage_bucket_cardinality | time
| Timestamp(Nanosecond, None) | NO |
| public | iox | storage_usage_bucket_cardinality | url
| Dictionary(Int32, Utf8) | YES |
+---------------+--------------+----------------------------------+--------------+-----------------------------+-------------+
**Expected behavior**
A clear and concise description of what you expected to happen.
**Additional context**
Add any other context about the problem here.
--
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-unsubscr...@arrow.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
