[jira] [Commented] (HIVE-17395) HiveServer2 parsing a command with a lot of "("

[ https://issues.apache.org/jira/browse/HIVE-17395?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16961647#comment-16961647 ] Greg Senia commented on HIVE-17395: --- After spending many hours troubleshooting this enh

[jira] [Comment Edited] (HIVE-18624) Parsing time is extremely high (~10 min) for queries with complex select expressions

[ https://issues.apache.org/jira/browse/HIVE-18624?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16961586#comment-16961586 ] Greg Senia edited comment on HIVE-18624 at 10/29/19 1:14 AM: -

[jira] [Commented] (HIVE-18624) Parsing time is extremely high (~10 min) for queries with complex select expressions

[ https://issues.apache.org/jira/browse/HIVE-18624?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16961586#comment-16961586 ] Greg Senia commented on HIVE-18624: --- Re-created this problem with a simple query as: Q

[jira] [Updated] (HIVE-18624) Parsing time is extremely high (~10 min) for queries with complex select expressions

[ https://issues.apache.org/jira/browse/HIVE-18624?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Greg Senia updated HIVE-18624: -- Affects Version/s: 2.0.0 > Parsing time is extremely high (~10 min) for queries with complex select >

[jira] [Commented] (HIVE-10511) Replacing the implementation of Hive CLI using Beeline

[ https://issues.apache.org/jira/browse/HIVE-10511?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15864981#comment-15864981 ] Greg Senia commented on HIVE-10511: --- [~gopalv] thank you for further insight. I wish all

[jira] [Commented] (HIVE-10511) Replacing the implementation of Hive CLI using Beeline

[ https://issues.apache.org/jira/browse/HIVE-10511?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15864337#comment-15864337 ] Greg Senia commented on HIVE-10511: --- [~gopalv] out of curiosity the big issue is HS2 has

[jira] [Commented] (HIVE-10511) Replacing the implementation of Hive CLI using Beeline

[ https://issues.apache.org/jira/browse/HIVE-10511?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15819606#comment-15819606 ] Greg Senia commented on HIVE-10511: --- I must ask the question how has this been looked at

[jira] [Commented] (HIVE-13020) Hive Metastore and HiveServer2 to Zookeeper fails with IBM JDK

[ https://issues.apache.org/jira/browse/HIVE-13020?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15142137#comment-15142137 ] Greg Senia commented on HIVE-13020: --- [~thejas] and [~gopalv] no problem > Hive Metastor

[jira] [Commented] (HIVE-13020) Hive Metastore and HiveServer2 to Zookeeper fails with IBM JDK

[ https://issues.apache.org/jira/browse/HIVE-13020?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15141562#comment-15141562 ] Greg Senia commented on HIVE-13020: --- [~gopalv] can you take a look at this patch and see

[jira] [Commented] (HIVE-7443) Fix HiveConnection to communicate with Kerberized Hive JDBC server and alternative JDKs

[ https://issues.apache.org/jira/browse/HIVE-7443?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15139638#comment-15139638 ] Greg Senia commented on HIVE-7443: -- [~crystal_gaoyu] did this fix ever make it into Hive?

[jira] [Commented] (HIVE-9545) Build FAILURE with IBM JVM

[ https://issues.apache.org/jira/browse/HIVE-9545?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15137134#comment-15137134 ] Greg Senia commented on HIVE-9545: -- Any way we can get these integrated into Hive??? If th

[jira] [Updated] (HIVE-13020) Hive Metastore and HiveServer2 to Zookeeper fails with IBM JDK

[ https://issues.apache.org/jira/browse/HIVE-13020?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Greg Senia updated HIVE-13020: -- Summary: Hive Metastore and HiveServer2 to Zookeeper fails with IBM JDK (was: Hive Zookeeper Connection

[jira] [Updated] (HIVE-13020) Hive Metastore and HiveServer2 to Zookeeper fails with IBM JDK

[ https://issues.apache.org/jira/browse/HIVE-13020?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Greg Senia updated HIVE-13020: -- Labels: hdp ibm ibm-jdk (was: ) > Hive Metastore and HiveServer2 to Zookeeper fails with IBM JDK >

[jira] [Updated] (HIVE-13020) Hive Zookeeper Connection From MetaStore and HiveServer2 fails with IBM JDK

[ https://issues.apache.org/jira/browse/HIVE-13020?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Greg Senia updated HIVE-13020: -- Attachment: hiveserver2_beforepatch.txt hiveserver2_afterpatch.txt hiveme

[jira] [Updated] (HIVE-13020) Hive Zookeeper Connection From MetaStore and HiveServer2 fails with IBM JDK

[ https://issues.apache.org/jira/browse/HIVE-13020?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Greg Senia updated HIVE-13020: -- Attachment: HIVE-13020.patch Patch > Hive Zookeeper Connection From MetaStore and HiveServer2 fails wit

[jira] [Commented] (HIVE-11051) Hive 1.2.0 MapJoin w/Tez - LazyBinaryArray cannot be cast to [Ljava.lang.Object;

[ https://issues.apache.org/jira/browse/HIVE-11051?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14599913#comment-14599913 ] Greg Senia commented on HIVE-11051: --- Fix looks good. Tested in our environment testing o

[jira] [Commented] (HIVE-10729) Query failed when select complex columns from joinned table (tez map join only)

[ https://issues.apache.org/jira/browse/HIVE-10729?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14598804#comment-14598804 ] Greg Senia commented on HIVE-10729: --- Gunther Hagleitner and Matt Mcline Using this Patch

[jira] [Updated] (HIVE-11051) Hive 1.2.0 MapJoin w/Tez - LazyBinaryArray cannot be cast to [Ljava.lang.Object;

[ https://issues.apache.org/jira/browse/HIVE-11051?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Greg Senia updated HIVE-11051: -- Component/s: Tez > Hive 1.2.0 MapJoin w/Tez - LazyBinaryArray cannot be cast to > [Ljava.lang.Object;

[jira] [Commented] (HIVE-11051) Hive 1.2.0 MapJoin w/Tez - LazyBinaryArray cannot be cast to [Ljava.lang.Object;

[ https://issues.apache.org/jira/browse/HIVE-11051?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14592882#comment-14592882 ] Greg Senia commented on HIVE-11051: --- This seems to be related/similar: http://stackoverf

[jira] [Commented] (HIVE-11051) Hive 1.2.0 MapJoin w/Tez - LazyBinaryArray cannot be cast to [Ljava.lang.Object;

[ https://issues.apache.org/jira/browse/HIVE-11051?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14592866#comment-14592866 ] Greg Senia commented on HIVE-11051: --- By setting the following Hive option the query will

[jira] [Updated] (HIVE-11051) Hive 1.2.0 MapJoin w/Tez - LazyBinaryArray cannot be cast to [Ljava.lang.Object;

[ https://issues.apache.org/jira/browse/HIVE-11051?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Greg Senia updated HIVE-11051: -- Description: I tried to apply: HIVE-10729 which did not solve the issue. The following exception is thr

[jira] [Updated] (HIVE-11051) Hive 1.2.0 LazyBinaryArray cannot be cast to [Ljava.lang.Object;

[ https://issues.apache.org/jira/browse/HIVE-11051?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Greg Senia updated HIVE-11051: -- Attachment: problem_table_joins.tar.gz Here are the tables and metadata to import for the re-create > H

[jira] [Updated] (HIVE-11051) Hive 1.2.0 LazyBinaryArray cannot be cast to [Ljava.lang.Object;

[ https://issues.apache.org/jira/browse/HIVE-11051?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Greg Senia updated HIVE-11051: -- Description: The following exception is thrown on a Tez MapJoin with Hive 1.2.0 and Tez 0.5.4/0.5.3 St

[jira] [Commented] (HIVE-10729) Query failed when select complex columns from joinned table (tez map join only)

[ https://issues.apache.org/jira/browse/HIVE-10729?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14591704#comment-14591704 ] Greg Senia commented on HIVE-10729: --- Any status on this jira is this stalled? Can i help

[jira] [Commented] (HIVE-10729) Query failed when select complex columns from joinned table (tez map join only)

[ https://issues.apache.org/jira/browse/HIVE-10729?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14578874#comment-14578874 ] Greg Senia commented on HIVE-10729: --- Here is a sample of the data I think the cause is t

[jira] [Commented] (HIVE-10729) Query failed when select complex columns from joinned table (tez map join only)

[ https://issues.apache.org/jira/browse/HIVE-10729?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14578856#comment-14578856 ] Greg Senia commented on HIVE-10729: --- Here is the query and source table describe that sh

[jira] [Commented] (HIVE-10729) Query failed when select complex columns from joinned table (tez map join only)

[ https://issues.apache.org/jira/browse/HIVE-10729?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14561260#comment-14561260 ] Greg Senia commented on HIVE-10729: --- I tried this patch with Hive 1.2.0 and I am still g

[jira] [Commented] (HIVE-10746) Hive 0.14.x and Hive 1.2.0 w/ Tez 0.5.3/Tez 0.6.0 Slow group by/order by

[ https://issues.apache.org/jira/browse/HIVE-10746?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14555456#comment-14555456 ] Greg Senia commented on HIVE-10746: --- After having offline discussion with Gopal V he det

[jira] [Commented] (HIVE-10746) Hive 0.14.x and Hive 1.2.0 w/ Tez 0.5.3/Tez 0.6.0 Slow group by/order by

[ https://issues.apache.org/jira/browse/HIVE-10746?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14553061#comment-14553061 ] Greg Senia commented on HIVE-10746: --- Debug logs from DAG with compressed it sets 1 split

[jira] [Commented] (HIVE-10746) Hive 0.14.x and Hive 1.2.0 w/ Tez 0.5.3/Tez 0.6.0 Slow group by/order by

[ https://issues.apache.org/jira/browse/HIVE-10746?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14553018#comment-14553018 ] Greg Senia commented on HIVE-10746: --- Just to clarify this data is tab delimited being lo

[jira] [Commented] (HIVE-10746) Hive 0.14.x and Hive 1.2.0 w/ Tez 0.5.3/Tez 0.6.0 Slow group by/order by

[ https://issues.apache.org/jira/browse/HIVE-10746?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14552976#comment-14552976 ] Greg Senia commented on HIVE-10746: --- With Compression with Snappy it ran in 7 seconds...

[jira] [Commented] (HIVE-10746) Hive 0.14.x and Hive 1.2.0 w/ Tez 0.5.3/Tez 0.6.0 Slow group by/order by

[ https://issues.apache.org/jira/browse/HIVE-10746?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14552833#comment-14552833 ] Greg Senia commented on HIVE-10746: --- hadoop fs -cat /example_dw/crc/arsn/part-m-0| w

[jira] [Commented] (HIVE-10746) Hive 0.14.x and Hive 1.2.0 w/ Tez 0.5.3/Tez 0.6.0 Slow group by/order by

[ https://issues.apache.org/jira/browse/HIVE-10746?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14552831#comment-14552831 ] Greg Senia commented on HIVE-10746: --- So it looks like it turned a 3MB file into 5GB wort

[jira] [Commented] (HIVE-10746) Hive 0.14.x and Hive 1.2.0 w/ Tez 0.5.3/Tez 0.6.0 Slow group by/order by

[ https://issues.apache.org/jira/browse/HIVE-10746?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14552793#comment-14552793 ] Greg Senia commented on HIVE-10746: --- I am guessing this JIRA could be the root of this i

[jira] [Commented] (HIVE-10746) Hive 0.14.x and Hive 1.2.0 w/ Tez 0.5.3/Tez 0.6.0 Slow group by/order by

[ https://issues.apache.org/jira/browse/HIVE-10746?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14552508#comment-14552508 ] Greg Senia commented on HIVE-10746: --- Seems to be that single file with a group by/order

[jira] [Commented] (HIVE-10746) Hive 0.14.x and Hive 1.2.0 w/ Tez 0.5.3/Tez 0.6.0 Slow group by/order by

[ https://issues.apache.org/jira/browse/HIVE-10746?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14550985#comment-14550985 ] Greg Senia commented on HIVE-10746: --- hive.exec.reducers.bytes.per.reducer=67108864; defa

[jira] [Commented] (HIVE-10746) Hive 0.14.x and Hive 1.2.0 w/ Tez 0.5.3/Tez 0.6.0 Slow group by/order by

[ https://issues.apache.org/jira/browse/HIVE-10746?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14550979#comment-14550979 ] Greg Senia commented on HIVE-10746: --- Mostafa Mokhtar: This isn't happening in the reduce