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

2020-01-02 Thread Sofia (Jira)
[ https://issues.apache.org/jira/browse/HIVE-21367?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17007014#comment-17007014 ] Sofia commented on HIVE-21367: -- [~sophie1] we re still using this workaround with the same version. I don't

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

2020-01-01 Thread sophie (Jira)
[ https://issues.apache.org/jira/browse/HIVE-21367?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17006465#comment-17006465 ] sophie commented on HIVE-21367: --- has this bug been fixed in a later version? Or need we still do the same

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

2019-03-05 Thread LEMBARKI Mohamed Amine (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-21367?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16784389#comment-16784389 ] LEMBARKI Mohamed Amine commented on HIVE-21367: --- Thanks [~starphin] for this Workaround :) 

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

2019-03-05 Thread Sofia (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-21367?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16784226#comment-16784226 ] Sofia commented on HIVE-21367: -- Both sqoop and spark makes subdirs. Setting property 

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

2019-03-04 Thread star (JIRA)
[ 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

2019-03-04 Thread Sofia (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-21367?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16783485#comment-16783485 ] Sofia commented on HIVE-21367: -- The target table is from two different sources : * {color:#33}*From

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

2019-03-04 Thread star (JIRA)
[ 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

2019-03-04 Thread LEMBARKI Mohamed Amine (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-21367?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16783299#comment-16783299 ] LEMBARKI Mohamed Amine commented on HIVE-21367: --- Hi, we've set the property 

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

2019-03-04 Thread star (JIRA)
[ 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

2019-03-04 Thread Sofia (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-21367?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16783236#comment-16783236 ] Sofia commented on HIVE-21367: -- Hi [~starphin],  why do hive behave that way and create subdirs when

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

2019-03-04 Thread LEMBARKI Mohamed Amine (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-21367?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16783205#comment-16783205 ] LEMBARKI Mohamed Amine commented on HIVE-21367: --- Hi, I just moved the files after tbl1,

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

2019-03-04 Thread star (JIRA)
[ 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

2019-03-02 Thread LEMBARKI Mohamed Amine (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-21367?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16782443#comment-16782443 ] LEMBARKI Mohamed Amine commented on HIVE-21367: --- Hi,  I tried to add this parameter when I

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

2019-03-01 Thread LEMBARKI Mohamed Amine (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-21367?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16781898#comment-16781898 ] LEMBARKI Mohamed Amine commented on HIVE-21367: --- Hi thank u I will try that ! > Hive

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

2019-03-01 Thread star (JIRA)
[ 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

2019-03-01 Thread star (JIRA)
[ 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

2019-03-01 Thread LEMBARKI Mohamed Amine (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-21367?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16781797#comment-16781797 ] LEMBARKI Mohamed Amine commented on HIVE-21367: --- Here is the HDFS Path to this table 

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

2019-03-01 Thread LEMBARKI Mohamed Amine (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-21367?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16781791#comment-16781791 ] LEMBARKI Mohamed Amine commented on HIVE-21367: --- Hi, {code:java} CREATE TABLE db1.tbl1(

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

2019-03-01 Thread star (JIRA)
[ 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