As already mentioned in a previous post, there is a serious issue with the usage of “NULL” in SELECT statements:
SELECT col1 as res1, NULL as res2 FROM somewhere.table
results in following error message:
Illegal use of ‘NULL’
Is this error message…
- caused by calcite, arrow or dremio
- intentionally (predetermined by architecture) or a bug?