[jira] [Commented] (HIVE-23880) Bloom filters can be merged in a parallel way in VectorUDAFBloomFilterMerge

[ https://issues.apache.org/jira/browse/HIVE-23880?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17621113#comment-17621113 ] Sungwoo commented on HIVE-23880: When hive.tez.bloom.filter.merge.threads is set to 1 (wh

[jira] [Commented] (HIVE-26621) TPC-DS query 2 fails with java.lang.RuntimeException: cannot find field _col0 from []

[ https://issues.apache.org/jira/browse/HIVE-26621?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17620656#comment-17620656 ] Sungwoo commented on HIVE-26621: This is caused by HIVE-24231. By setting hive.optimize.s

[jira] [Comment Edited] (HIVE-24167) TPC-DS query 14 fails while generating plan for the filter

[ https://issues.apache.org/jira/browse/HIVE-24167?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17619961#comment-17619961 ] Sungwoo edited comment on HIVE-24167 at 10/19/22 3:26 AM: -- This

[jira] [Commented] (HIVE-24167) TPC-DS query 14 fails while generating plan for the filter

[ https://issues.apache.org/jira/browse/HIVE-24167?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17619961#comment-17619961 ] Sungwoo commented on HIVE-24167: This bug is produce since HIVE-24081. A workaround is to

[jira] [Commented] (HIVE-26573) ClassCastException error on window function

[ https://issues.apache.org/jira/browse/HIVE-26573?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17618357#comment-17618357 ] Sungwoo commented on HIVE-26573: How did you create your TPC-DS dataset? I tested with th

[jira] [Updated] (HIVE-26621) TPC-DS query 2 fails with java.lang.RuntimeException: cannot find field _col0 from []

[ https://issues.apache.org/jira/browse/HIVE-26621?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sungwoo updated HIVE-26621: --- Priority: Major (was: Critical) > TPC-DS query 2 fails with java.lang.RuntimeException: cannot find field _c

[jira] [Commented] (HIVE-26621) TPC-DS query 2 fails with java.lang.RuntimeException: cannot find field _col0 from []

[ https://issues.apache.org/jira/browse/HIVE-26621?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17615856#comment-17615856 ] Sungwoo commented on HIVE-26621: A workaround is to set hive.tez.dynamic.semijoin.reducti

[jira] [Commented] (HIVE-26621) TPC-DS query 2 fails with java.lang.RuntimeException: cannot find field _col0 from []

[ https://issues.apache.org/jira/browse/HIVE-26621?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17615850#comment-17615850 ] Sungwoo commented on HIVE-26621: I used the master branch, commit 57d1ad69f56f990d387b4a4

[jira] [Updated] (HIVE-26621) TPC-DS query 2 fails with java.lang.RuntimeException: cannot find field _col0 from []

[ https://issues.apache.org/jira/browse/HIVE-26621?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sungwoo updated HIVE-26621: --- Description: How to reproduce: 1. Build Hive using the master branch. Tez version is 0.10.2. 2. Generate 10

[jira] [Updated] (HIVE-26621) TPC-DS query 2 fails with java.lang.RuntimeException: cannot find field _col0 from []

[ https://issues.apache.org/jira/browse/HIVE-26621?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sungwoo updated HIVE-26621: --- Affects Version/s: 4.0.0-alpha-1 > TPC-DS query 2 fails with java.lang.RuntimeException: cannot find field _c

[jira] [Updated] (HIVE-26621) TPC-DS query 2 fails with java.lang.RuntimeException: cannot find field _col0 from []

[ https://issues.apache.org/jira/browse/HIVE-26621?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sungwoo updated HIVE-26621: --- Priority: Critical (was: Major) > TPC-DS query 2 fails with java.lang.RuntimeException: cannot find field _c

[jira] [Commented] (HIVE-26573) ClassCastException error on window function

[ https://issues.apache.org/jira/browse/HIVE-26573?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17612051#comment-17612051 ] Sungwoo commented on HIVE-26573: FYI, this query runs without a problem on Hive 3.1.3 (wi

[jira] [Commented] (HIVE-26465) datediff wrong result cause by vectorized execution

[ https://issues.apache.org/jira/browse/HIVE-26465?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17579312#comment-17579312 ] Sungwoo commented on HIVE-26465: It seems that HIVE-22476 fixes this bug. > datediff wro

[jira] [Commented] (HIVE-24590) Operation Logging still leaks the log4j Appenders

[ https://issues.apache.org/jira/browse/HIVE-24590?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17404424#comment-17404424 ] Sungwoo commented on HIVE-24590: I find that similarly to calling ThreadContext.clearAll(

[jira] [Commented] (HIVE-24316) Upgrade ORC from 1.5.6 to 1.5.8 in branch-3.1

[ https://issues.apache.org/jira/browse/HIVE-24316?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17403893#comment-17403893 ] Sungwoo commented on HIVE-24316: Hello, It seems that with ORC-361, the use of MemoryMan

[jira] [Commented] (HIVE-24849) Create external table socket timeout when location has large number of files

[ https://issues.apache.org/jira/browse/HIVE-24849?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17395153#comment-17395153 ] Sungwoo commented on HIVE-24849: [~ste...@apache.org], Could you elaborate on how FileSy

[jira] [Commented] (HIVE-25277) Slow Hive partition deletion for Cloud object stores with expensive ListFiles

[ https://issues.apache.org/jira/browse/HIVE-25277?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17395105#comment-17395105 ] Sungwoo commented on HIVE-25277: In HIVE-24849, isEmpty() is rewritten to call FileSystem

[jira] [Commented] (HIVE-24849) Create external table socket timeout when location has large number of files

[ https://issues.apache.org/jira/browse/HIVE-24849?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17395101#comment-17395101 ] Sungwoo commented on HIVE-24849: Upon further inspection, the above pull request is enoug

[jira] [Comment Edited] (HIVE-24849) Create external table socket timeout when location has large number of files

[ https://issues.apache.org/jira/browse/HIVE-24849?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17395101#comment-17395101 ] Sungwoo edited comment on HIVE-24849 at 8/7/21, 5:31 AM: - Upon fu

[jira] [Updated] (HIVE-24849) Create external table socket timeout when location has large number of files

[ https://issues.apache.org/jira/browse/HIVE-24849?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sungwoo updated HIVE-24849: --- Affects Version/s: 4.0.0 3.1.2 > Create external table socket timeout when location ha

[jira] [Commented] (HIVE-24849) Create external table socket timeout when location has large number of files

[ https://issues.apache.org/jira/browse/HIVE-24849?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17394678#comment-17394678 ] Sungwoo commented on HIVE-24849: I have created a pull request (for the master branch):

[jira] [Commented] (HIVE-24849) Create external table socket timeout when location has large number of files

[ https://issues.apache.org/jira/browse/HIVE-24849?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17371947#comment-17371947 ] Sungwoo commented on HIVE-24849: {code:java} public boolean isEmpty() throws HiveExcept

[jira] [Comment Edited] (HIVE-24849) Create external table socket timeout when location has large number of files

[ https://issues.apache.org/jira/browse/HIVE-24849?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17371947#comment-17371947 ] Sungwoo edited comment on HIVE-24849 at 6/30/21, 11:10 AM: --- {co

[jira] [Commented] (HIVE-24907) Wrong results with LEFT JOIN and subqueries with UNION and GROUP BY

[ https://issues.apache.org/jira/browse/HIVE-24907?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17305289#comment-17305289 ] Sungwoo commented on HIVE-24907: Hi [~zabetak], I reproduced the wrong result. The resul

[jira] [Commented] (HIVE-24907) Wrong results with LEFT JOIN and subqueries with UNION and GROUP BY

[ https://issues.apache.org/jira/browse/HIVE-24907?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17304540#comment-17304540 ] Sungwoo commented on HIVE-24907: FYI, when tested with Hive 3.1, the query returns a corr

[jira] [Commented] (HIVE-24849) Create external table socket timeout when location has large number of files

[ https://issues.apache.org/jira/browse/HIVE-24849?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17300233#comment-17300233 ] Sungwoo commented on HIVE-24849: I think both HiveServer2 and Metastore try connections t

[jira] [Commented] (HIVE-23114) Insert overwrite with dynamic partitioning is not working correctly with direct insert

[ https://issues.apache.org/jira/browse/HIVE-23114?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17078406#comment-17078406 ] Sungwoo commented on HIVE-23114: I tested with the new commit using HDFS. The ORC databas

[jira] [Comment Edited] (HIVE-23114) Insert overwrite with dynamic partitioning is not working correctly with direct insert

[ https://issues.apache.org/jira/browse/HIVE-23114?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17078406#comment-17078406 ] Sungwoo edited comment on HIVE-23114 at 4/8/20, 3:47 PM: - I teste

[jira] [Commented] (HIVE-23114) Insert overwrite with dynamic partitioning is not working correctly with direct insert

[ https://issues.apache.org/jira/browse/HIVE-23114?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17077612#comment-17077612 ] Sungwoo commented on HIVE-23114: Hello [~kuczoram], I tried this combination: HIVE-21164

[jira] [Commented] (HIVE-23114) Insert overwrite with dynamic partitioning is not working correctly with direct insert

[ https://issues.apache.org/jira/browse/HIVE-23114?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17072165#comment-17072165 ] Sungwoo commented on HIVE-23114: I tried 1.patch with Hive 4 on Tez with these commits:

[jira] [Commented] (HIVE-21164) ACID: explore how we can avoid a move step during inserts/compaction

[ https://issues.apache.org/jira/browse/HIVE-21164?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17064788#comment-17064788 ] Sungwoo commented on HIVE-21164: I tested with Hive 4 on Tez, and confirm that the same p

[jira] [Commented] (HIVE-21164) ACID: explore how we can avoid a move step during inserts/compaction

[ https://issues.apache.org/jira/browse/HIVE-21164?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17062047#comment-17062047 ] Sungwoo commented on HIVE-21164: [~kuczoram] Do you know if Utilities.handleDirectInsertT

[jira] [Commented] (HIVE-21164) ACID: explore how we can avoid a move step during inserts/compaction

[ https://issues.apache.org/jira/browse/HIVE-21164?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17060447#comment-17060447 ] Sungwoo commented on HIVE-21164: [~kuczoram] In my testing, both select queries return no

[jira] [Commented] (HIVE-21164) ACID: explore how we can avoid a move step during inserts/compaction

[ https://issues.apache.org/jira/browse/HIVE-21164?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17060020#comment-17060020 ] Sungwoo commented on HIVE-21164: [~gopalv] Yes, the problem can be due to mishandling of

[jira] [Commented] (HIVE-21164) ACID: explore how we can avoid a move step during inserts/compaction

[ https://issues.apache.org/jira/browse/HIVE-21164?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17059491#comment-17059491 ] Sungwoo commented on HIVE-21164: Hello Marta, I wonder if you have a plan to try to repr

[jira] [Comment Edited] (HIVE-22371) CTAS not working with non-ACID managed tables

[ https://issues.apache.org/jira/browse/HIVE-22371?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17059292#comment-17059292 ] Sungwoo edited comment on HIVE-22371 at 3/14/20, 9:49 AM: -- A wor

[jira] [Commented] (HIVE-22371) CTAS not working with non-ACID managed tables

[ https://issues.apache.org/jira/browse/HIVE-22371?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17059292#comment-17059292 ] Sungwoo commented on HIVE-22371: A workaround is to explicitly specify table properties,

[jira] [Commented] (HIVE-21164) ACID: explore how we can avoid a move step during inserts/compaction

[ https://issues.apache.org/jira/browse/HIVE-21164?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17059280#comment-17059280 ] Sungwoo commented on HIVE-21164: I have tested this commit (in the master branch) with TP