elbaro commented on issue #5187:
URL:
https://github.com/apache/arrow-datafusion/issues/5187#issuecomment-1428089611
I see. Is this api intended or in progress?
If I had to add double quotes in everywhere it would be very hard to use.
```
SELECT "a".col1, "b".col2 FROM a JOIN b ON "a".col3="b".col3
```
If a dot in column names is uncommon, I suggest this style (so that writing
is as easy as SQL)
```
col("a.col") => ("a", "col")
Column::new(None, "a.col") => (None, "a.col")
```
Also, when are we allowed to skip ?table?
The following example from the doc uses col("a") without ?table?.
```rs
// create the dataframe
let df = ctx.read_csv("tests/data/example.csv",
CsvReadOptions::new()).await?;
// create a plan
let df = df.filter(col("a").lt_eq(col("b")))? // why is this not
col("\"?table?\".a")
.aggregate(vec![col("a")], vec![min(col("b"))])?
.limit(0, Some(100))?;
```
--
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]
