[GitHub] [arrow-datafusion] jychen7 commented on issue #1507: Python bindings create duplicated qualified fields after joining

[GitBox <gi...@apache.org>]

jychen7 commented on issue #1507:
URL: https://github.com/apache/arrow-datafusion/issues/1507#issuecomment-1013921187


   I think it is just python. I try following in datafusion-cli and works
   ```
   select * from test join small using (c1);
   ```
   with
   ```
   CREATE EXTERNAL TABLE test (
       c1  VARCHAR NOT NULL,
       c2  INT NOT NULL,
       c3  SMALLINT NOT NULL,
       c4  SMALLINT NOT NULL,
       c5  INT NOT NULL,
       c6  BIGINT NOT NULL,
       c7  SMALLINT NOT NULL,
       c8  INT NOT NULL,
       c9  BIGINT NOT NULL,
       c10 VARCHAR NOT NULL,
       c11 FLOAT NOT NULL,
       c12 DOUBLE NOT NULL,
       c13 VARCHAR NOT NULL
   )
   STORED AS CSV
   WITH HEADER ROW
   LOCATION '/testing/data/csv/aggregate_test_100.csv';
   
   CREATE EXTERNAL TABLE small (
       c1  VARCHAR NOT NULL,
       c2  INT NOT NULL,
       c3  SMALLINT NOT NULL,
       c4  SMALLINT NOT NULL,
       c5  INT NOT NULL,
       c6  BIGINT NOT NULL,
       c7  SMALLINT NOT NULL,
       c8  INT NOT NULL,
       c9  BIGINT NOT NULL,
       c10 VARCHAR NOT NULL,
       c11 FLOAT NOT NULL,
       c12 DOUBLE NOT NULL,
       c13 VARCHAR NOT NULL
   )
   STORED AS CSV
   WITH HEADER ROW
   LOCATION '/testing/data/csv/aggregate_test_100.csv';
   ```


-- 
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