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

   **Describe the bug**
   
   ## DataFusion 10.0 supports this query:
   
   ```
   ❯ select y.column_1 z, sum(column_2) q from x y group by y.column_1 order by 
y.column_1;
   +---+---+
   | z | q |
   +---+---+
   | 1 | 2 |
   +---+---+
   ```
   
   ## DataFusion master fails:
   
   ```
   ❯ select y.column_1 z, sum(column_2) q from x y group by y.column_1 order by 
y.column_1;
   SchemaError(FieldNotFound { qualifier: Some("y"), name: "column_1", 
valid_fields: Some(["z", "q"]) })
   ```
   
   **To Reproduce**
   
   ```
   echo "1,2" > data.csv
   create external table x stored as csv location 'data.csv';
   ```
   
   **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