Skip to content

INTEGER type does't work while importing csv #3059

Closed

Description

@waitingkuo

Describe the bug
A clear and concise description of what the bug is.

it works at v10.0.0, but doesn't work at master branch

To Reproduce
Steps to reproduce the behavior:

echo "a\n1" > b.csv

➜  datafusion-cli git:(master) ✗ cargo run
    Finished dev [unoptimized + debuginfo] target(s) in 0.26s
     Running `target/debug/datafusion-cli`
DataFusion CLI v10.0.0
❯ create external table b (a INTEGER) stored as csv with header row location 'b.csv';
NotImplemented("The SQL data type Integer(None) is not implemented")

while this works

❯ create external table b (a INT) stored as csv with header row location 'b.csv';
0 rows in set. Query took 0.016 seconds.

Expected behavior
A clear and concise description of what you expected to happen.

Additional context
Add any other context about the problem here.

Activity

  1. alamb commented on Aug 15, 2022

    @alamb
    Contributor

    This is probably due to apache/datafusion-sqlparser-rs#525 --

  2. alamb commented on Aug 15, 2022

    @alamb
    Contributor

    As this is a regression it would be nice to fix before 11 -- I will do so

  3. self-assigned this
    on Aug 15, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

Labels

bugSomething isn't working

Type

No type

Projects

No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions