You are viewing a plain text version of this content. The canonical link for it is here.
Posted to github@arrow.apache.org by "universalmind303 (via GitHub)" <gi...@apache.org> on 2024/02/07 19:37:17 UTC
[I] `arrow_cast` does not work in `insert` statements [arrow-datafusion]
universalmind303 opened a new issue, #9151:
URL: https://github.com/apache/arrow-datafusion/issues/9151
### Describe the bug
`arrow_cast` does not work within an `insert` statement
### To Reproduce
```sql
statement ok
create table test as (select arrow_cast([1,2], 'FixedSizeList(2, Int64)') as f);
statement ok
insert into test values ([1, 2]);
statement error # this should be ok
insert into test values (arrow_cast([1,2], 'FixedSizeList(2, Int64)') );
# Internal error: Unsupported creation of FixedSizeList(Field { name: "item", data_type: Int64, nullable: true, dict_id: 0, dict_is_ordered: false, metadata: {} }, 2) array from ScalarValue Some(FixedSizeList([1, 2])).
# This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
### Expected behavior
_No response_
### Additional context
_No response_
--
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: github-unsubscribe@arrow.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] `arrow_cast` does not work in `insert` statements [arrow-datafusion]
Posted by "Weijun-H (via GitHub)" <gi...@apache.org>.
Weijun-H commented on issue #9151:
URL: https://github.com/apache/arrow-datafusion/issues/9151#issuecomment-1933258538
This issue seems to have been resolved.
```
DataFusion CLI v35.0.0
❯ create table test as (select arrow_cast([1,2], 'FixedSizeList(2, Int64)') as f);
0 rows in set. Query took 0.010 seconds.
❯ insert into test values ([1, 2]);
+-------+
| count |
+-------+
| 1 |
+-------+
1 row in set. Query took 0.006 seconds.
❯ insert into test values (arrow_cast([1,2], 'FixedSizeList(2, Int64)') );
+-------+
| count |
+-------+
| 1 |
+-------+
1 row in set. Query took 0.004 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: github-unsubscribe@arrow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] `arrow_cast` does not work in `insert` statements [arrow-datafusion]
Posted by "jayzhan211 (via GitHub)" <gi...@apache.org>.
jayzhan211 closed issue #9151: `arrow_cast` does not work in `insert` statements
URL: https://github.com/apache/arrow-datafusion/issues/9151
--
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: github-unsubscribe@arrow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] `arrow_cast` does not work in `insert` statements [arrow-datafusion]
Posted by "universalmind303 (via GitHub)" <gi...@apache.org>.
universalmind303 commented on issue #9151:
URL: https://github.com/apache/arrow-datafusion/issues/9151#issuecomment-1932817861
likely related to https://github.com/apache/arrow-datafusion/issues/9143
--
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: github-unsubscribe@arrow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] `arrow_cast` does not work in `insert` statements [arrow-datafusion]
Posted by "alamb (via GitHub)" <gi...@apache.org>.
alamb commented on issue #9151:
URL: https://github.com/apache/arrow-datafusion/issues/9151#issuecomment-1933245447
@Weijun-H may already be working on this
--
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: github-unsubscribe@arrow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org