You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@arrow.apache.org by "Morgan Cassels (Jira)" <ji...@apache.org> on 2020/10/16 17:57:00 UTC
[jira] [Created] (ARROW-10329) Datafusion queries involving a
column name that begins with a number produces unexpected results
Morgan Cassels created ARROW-10329:
--------------------------------------
Summary: Datafusion queries involving a column name that begins with a number produces unexpected results
Key: ARROW-10329
URL: https://issues.apache.org/jira/browse/ARROW-10329
Project: Apache Arrow
Issue Type: Bug
Components: Rust - DataFusion
Reporter: Morgan Cassels
This bug can be worked around by wrapping column names in quotes.
Example:
{{let query = "SELECT 16_20mph, 21_25mph FROM foo;"}}
{{let logical_plan = ctx.create_logical_plan(query)?;}}
{{logical_plan.schema().fields() }}now has fields: {{_20mph, _25mph}}
The resulting table produced by this query looks like:
||{{_20mph}}||{{_25mph}}||
|16|21|
|16|21|
Every row is identical, where the column value is equal to the initial number that appears in the column name.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)