alamb commented on code in PR #4984: URL: https://github.com/apache/arrow-datafusion/pull/4984#discussion_r1081343683
########## docs/source/user-guide/sql/data_types.md: ########## @@ -25,13 +25,26 @@ execution. The SQL types from are mapped to [Arrow data types](https://docs.rs/arrow/latest/arrow/datatypes/enum.DataType.html) according to the following table. This mapping occurs when defining the schema in a `CREATE EXTERNAL TABLE` command or when performing a SQL `CAST` operation. +You can see the corresponding Arrow type for any SQL expression using +the `arrow_typeof` function. For example: + +```sql +❯ select arrow_typeof(interval '1 month'); ++-------------------------------------+ +| arrowtypeof(IntervalYearMonth("1")) | ++-------------------------------------+ +| Interval(YearMonth) | ++-------------------------------------+ +``` + ## Character Types | SQL DataType | Arrow DataType | | ------------ | -------------- | | `CHAR` | `Utf8` | | `VARCHAR` | `Utf8` | | `TEXT` | `Utf8` | +| `STRING` | `Utf8` | Review Comment: ```sql ❯ create table foo (x string) as select 'foo'; 0 rows in set. Query took 0.003 seconds. ``` -- 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]
