[jira] [Commented] (HIVE-21485) Hive desc operation takes more than 100 seconds after upgrading from Hive 1.2.1 to 2.3.4

[ https://issues.apache.org/jira/browse/HIVE-21485?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16799248#comment-16799248 ] star commented on HIVE-21485: -  You can set parameter like set hive.display.partitioned.table.stats=false to

[jira] [Comment Edited] (HIVE-21485) Hive desc operation takes more than 100 seconds after upgrading from Hive 1.2.1 to 2.3.4

[ https://issues.apache.org/jira/browse/HIVE-21485?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16798594#comment-16798594 ] star edited comment on HIVE-21485 at 3/22/19 12:49 AM: --- Maybe table with so much

[jira] [Commented] (HIVE-21485) Hive desc operation takes more than 100 seconds after upgrading from Hive 1.2.1 to 2.3.4

[ https://issues.apache.org/jira/browse/HIVE-21485?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16798594#comment-16798594 ] star commented on HIVE-21485: - Maybe table with so much partition is not a good practice. > Hive desc

[jira] [Commented] (HIVE-21367) Hive returns an incorrect result when using a simple select query

[ https://issues.apache.org/jira/browse/HIVE-21367?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16783978#comment-16783978 ] star commented on HIVE-21367: - Can you verify which one , sqoop or spark, makes subdirs? Also setting

[jira] [Commented] (HIVE-21367) Hive returns an incorrect result when using a simple select query

[ https://issues.apache.org/jira/browse/HIVE-21367?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16783445#comment-16783445 ] star commented on HIVE-21367: - Seems it only takes effect in mapreduce, not fetchtask. I have to figure out

[jira] [Commented] (HIVE-21367) Hive returns an incorrect result when using a simple select query

[ https://issues.apache.org/jira/browse/HIVE-21367?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16783264#comment-16783264 ] star commented on HIVE-21367: - Basically hive will change a simple select into 'FetchTask' which will be

[jira] [Commented] (HIVE-21367) Hive returns an incorrect result when using a simple select query

[ https://issues.apache.org/jira/browse/HIVE-21367?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16783114#comment-16783114 ] star commented on HIVE-21367: - Or you can mv files from subdirs to the root dir of the table. I suspect that

[jira] [Commented] (HIVE-21367) Hive returns an incorrect result when using a simple select query

[ https://issues.apache.org/jira/browse/HIVE-21367?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16781837#comment-16781837 ] star commented on HIVE-21367: - try set parameters as following:  set hive.input.dir.recursive=true; set

[jira] [Commented] (HIVE-21367) Hive returns an incorrect result when using a simple select query

[ https://issues.apache.org/jira/browse/HIVE-21367?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16781830#comment-16781830 ] star commented on HIVE-21367: - You can make some meaningless data and reproduce the bug.  > Hive returns an

[jira] [Commented] (HIVE-21367) Hive returns an incorrect result when using a simple select query

[ https://issues.apache.org/jira/browse/HIVE-21367?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16781766#comment-16781766 ] star commented on HIVE-21367: - Could you please upload hdfs file corresponding to that table and show create