andygrove opened a new issue, #3002:
URL: https://github.com/apache/arrow-datafusion/issues/3002

   **Describe the bug**
   
   I am trying to perform a trivial join in the CLI using latest from master 
and I get the following error:
   
   ```
   Plan("The expression to get an indexed field is only valid for `List` types")
   ```
   
   
   **To Reproduce**
   
   ```
   $ cat /tmp/a.csv
   foo
   1
   
   $ cat /tmp/b.csv
   b
   bar
   
   $ ./target/debug/datafusion-cli
   
   DataFusion CLI v10.0.0
   ❯ create external table a stored as csv with header row location 
'/tmp/a.csv';
   0 rows in set. Query took 0.016 seconds.
   ❯ create external table b stored as csv with header row location 
'/tmp/b.csv';
   0 rows in set. Query took 0.009 seconds.
   ❯ select * from a;
   +-----+
   | foo |
   +-----+
   | 1   |
   +-----+
   1 row in set. Query took 0.011 seconds.
   ❯ select * from b;
   +-----+
   | b   |
   +-----+
   | bar |
   +-----+
   1 row in set. Query took 0.010 seconds.
   ❯ select * from a join b on a.foo = b.bar;
   Plan("The expression to get an indexed field is only valid for `List` types")
   ```
   
   **Expected behavior**
   Query should work
   
   **Additional context**
   None
   


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to