Jefffrey commented on PR #11006:
URL: https://github.com/apache/arrow-rs/pull/11006#issuecomment-5560459866
this doesnt seem accepted by either spark or duckdb
duckdb:
```sql
memory D select interval '5 day hour';
Conversion Error:
Could not convert string '5 day hour' to INTERVAL
LINE 1: select interval '5 day hour';
```
spark:
```python
Traceback (most recent call last):
File "<python-input-4>", line 1, in <module>
spark.sql("select interval '5 day hour'").show()
~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File
"/Users/jeffrey/.cache/uv/archive-v0/DYpV4hSlk1WPp1Lj/lib/python3.13/site-packages/pyspark/sql/session.py",
line 1915, in sql
return DataFrame(self._jsparkSession.sql(sqlQuery, litArgs), self)
~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^
File
"/Users/jeffrey/.cache/uv/archive-v0/DYpV4hSlk1WPp1Lj/lib/python3.13/site-packages/py4j/java_gateway.py",
line 1362, in __call__
return_value = get_return_value(
answer, self.gateway_client, self.target_id, self.name)
File
"/Users/jeffrey/.cache/uv/archive-v0/DYpV4hSlk1WPp1Lj/lib/python3.13/site-packages/pyspark/errors/exceptions/captured.py",
line 257, in deco
raise converted from None
pyspark.errors.exceptions.captured.ParseException:
[INVALID_TYPED_LITERAL] The value of the typed literal "INTERVAL" is
invalid: '5 day hour'. SQLSTATE: 42604
== SQL (line 1, position 8) ==
select interval '5 day hour'
```
so im pretty lukewarm on accepting this, especially as it just doesnt read
quite well as an interval; it reads more like a mistake from postgres'
permissive parsing
--
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]
