You are viewing a plain text version of this content. The canonical link for it is here.
Posted to github@arrow.apache.org by "yukkit (via GitHub)" <gi...@apache.org> on 2023/02/24 02:49:35 UTC

[GitHub] [arrow-datafusion] yukkit opened a new issue, #5382: Failed to run SQL that uses full outer join with a boolean literal join condition

yukkit opened a new issue, #5382:
URL: https://github.com/apache/arrow-datafusion/issues/5382

   **Describe the bug**
   A clear and concise description of what the bug is.
   
   **To Reproduce**
   Steps to reproduce the behavior:
   
   ```shell
   DataFusion CLI v18.0.0
   ❯ create table test1(intt int, inttt int) as select 1 as intt, 2 as inttt;
   0 rows in set. Query took 0.017 seconds.
   ❯ create table test2(intt int, inttt int) as select 1 as intt, 2 as inttt;
   0 rows in set. Query took 0.006 seconds.
   ❯ SELECT *
   FROM test2
           FULL JOIN test1 ON true;
   Execution error: Build left right indices error
   ❯ 
   ```
   
   **Expected behavior**
   A clear and concise description of what you expected to happen.
   
   return the correct record
   
   **Additional context**
   Add any other context about the problem here.
   


-- 
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

[GitHub] [arrow-datafusion] ygf11 commented on issue #5382: Failed to run SQL that uses full outer join with a boolean literal join condition

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

   Seems it is caused by trying to create RecordBatch with empty schema.
   https://github.com/apache/arrow-datafusion/blob/c676d1026f8fa25c1495ec139b8a379ce1f2f86b/datafusion/core/src/physical_plan/joins/utils.rs#L823
   
   The row count is inferred from columns, but the columns is also empty here.
   
   We can use `RecordBatch::try_new_with_options` with specifying the row count.
   https://github.com/apache/arrow-rs/blob/e7eb304dac442a943c434f8ea248de909f82aa88/arrow-array/src/record_batch.rs#L107-L113
   


-- 
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

[GitHub] [arrow-datafusion] jackwener commented on issue #5382: Failed to run SQL that uses full outer join with a boolean literal join condition

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

   fail in `build_batch_from_indices`.
   
   cc @liukun4515 @ygf11 


-- 
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

[GitHub] [arrow-datafusion] alamb closed issue #5382: Failed to run SQL that uses full outer join with a boolean literal join condition

Posted by "alamb (via GitHub)" <gi...@apache.org>.
alamb closed issue #5382: Failed to run SQL that uses full outer join with a boolean literal join condition
URL: https://github.com/apache/arrow-datafusion/issues/5382


-- 
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