apache / apache/pinot

Columns with CAST in the select statement are return as OBJECT data types in the resultSet

Open
#11,629 3 comments 0 reactions 0 assignees View on GitHub
bug
Dominant language
Java
Stars
6.1k
Forks
1.5k
Avg merge
2d 55m
Merged PRs (30d)
182

Description

We had a query that was doing `select long_column from X`. The user updated it to do `select long_column - Y from X`. This change the `columnDataTypes` for this to a `DOUBLE`. The user's assertions on column types broke, so they changed it to `SELECT CAST(long_column - Y AS LONG) from X`. But this also didn't work because `columnDataTypes` then showed `OBJECT`.

For `CAST`, the expectation is a successful result would show the casted data type

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.