You are viewing a plain text version of this content. The canonical link for it is here.
Posted to github@datafusion.apache.org by "adriangb (via GitHub)" <gi...@apache.org> on 2024/11/22 23:54:42 UTC

[I] Simple query fails with `column types must match schema types` [datafusion]

adriangb opened a new issue, #13534:
URL: https://github.com/apache/datafusion/issues/13534

   ### Describe the bug
   
   Found in our production system using datafusion internals, but reproducible in `datafusion-cli`:
   
   ```sql
   SELECT
       'foo' AS text,
       arrow_cast('2024-01-01T00:00:00Z'::timestamptz, 'Timestamp(Microsecond, Some("UTC"))') AS ts
   GROUP BY ts, text
   ```
   
   Gives:
   
   ```
   Arrow error: Invalid argument error: column types must match schema types, expected Timestamp(Microsecond, Some("UTC")) but found Timestamp(Microsecond, None) at column index 0
   ```
   
   ### To Reproduce
   
   _No response_
   
   ### Expected behavior
   
   _No response_
   
   ### Additional context
   
   I bisected it with this script:
   
   ```shell
   pushd datafusion-cli && cargo run --bin datafusion-cli -- --file ../q.sql && popd
   ```
   
   And then:
   
   ```shell
   git checkout c0ca4b4  # current HEAD
   git bisect start
   git bisect bad
   git checkout 88f58bf # 43.0, I manually verified it is okay
   git bisect good
   git bisect run ./test.sh  # the above script
   ```
   
   The result points to ecc04d4af85a29111a1598e615350fea84e60fcb / https://github.com/apache/datafusion/pull/13457


-- 
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@datafusion.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org


Re: [I] Simple query fails with `column types must match schema types` [datafusion]

Posted by "alamb (via GitHub)" <gi...@apache.org>.
alamb commented on issue #13534:
URL: https://github.com/apache/datafusion/issues/13534#issuecomment-2495452449

   @jayzhan211  is on the case:
   - https://github.com/apache/datafusion/pull/13535


-- 
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@datafusion.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org


Re: [I] Simple query fails with `column types must match schema types` [datafusion]

Posted by "adriangb (via GitHub)" <gi...@apache.org>.
adriangb commented on issue #13534:
URL: https://github.com/apache/datafusion/issues/13534#issuecomment-2495114051

   cc @jonathanc-n @jayzhan211 @alamb


-- 
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@datafusion.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org


Re: [I] Simple query fails with `column types must match schema types` [datafusion]

Posted by "alamb (via GitHub)" <gi...@apache.org>.
alamb closed issue #13534: Simple query fails with `column types must match schema types`
URL: https://github.com/apache/datafusion/issues/13534


-- 
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@datafusion.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org


Re: [I] Simple query fails with `column types must match schema types` [datafusion]

Posted by "alamb (via GitHub)" <gi...@apache.org>.
alamb commented on issue #13534:
URL: https://github.com/apache/datafusion/issues/13534#issuecomment-2495453016

   I think this issue was introduced in 
   - https://github.com/apache/datafusion/pull/13457
   
   Which has not been released yet 


-- 
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@datafusion.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org