[jira] Updated: (HIVE-347) [hive] lot of mappers due to a user error while specifying the partitioning column
[ https://issues.apache.org/jira/browse/HIVE-347?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Namit Jain updated HIVE-347: Attachment: hive.347.4.patch [hive] lot of mappers due to a user error while specifying the partitioning column -- Key: HIVE-347 URL: https://issues.apache.org/jira/browse/HIVE-347 Project: Hadoop Hive Issue Type: Bug Components: Query Processor Reporter: Namit Jain Assignee: Namit Jain Fix For: 0.3.0 Attachments: hive.347.1.patch, hive.347.2.patch, hive.347.3.patch, hive.347.4.patch A common scenario when the table is partitioned on 'ds' column which is of type 'string' of a certain format '-mm-dd' However, if the user forgets to add quotes while specifying the query: select ... from T where ds = 2009-02-02 2009-02-02 is a valid integer expression. So, partition pruning makes all partitions unknown, since 2009-02-02 to double conversion is null. If all partitions are unknown, in strict mode, we should thrown an error -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
[jira] Updated: (HIVE-347) [hive] lot of mappers due to a user error while specifying the partitioning column
[ https://issues.apache.org/jira/browse/HIVE-347?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Namit Jain updated HIVE-347: Status: Patch Available (was: Reopened) [hive] lot of mappers due to a user error while specifying the partitioning column -- Key: HIVE-347 URL: https://issues.apache.org/jira/browse/HIVE-347 Project: Hadoop Hive Issue Type: Bug Components: Query Processor Reporter: Namit Jain Assignee: Namit Jain Fix For: 0.3.0 Attachments: hive.347.1.patch, hive.347.2.patch, hive.347.3.patch, hive.347.4.patch A common scenario when the table is partitioned on 'ds' column which is of type 'string' of a certain format '-mm-dd' However, if the user forgets to add quotes while specifying the query: select ... from T where ds = 2009-02-02 2009-02-02 is a valid integer expression. So, partition pruning makes all partitions unknown, since 2009-02-02 to double conversion is null. If all partitions are unknown, in strict mode, we should thrown an error -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
[jira] Updated: (HIVE-347) [hive] lot of mappers due to a user error while specifying the partitioning column
[ https://issues.apache.org/jira/browse/HIVE-347?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Namit Jain updated HIVE-347: Resolution: Fixed Status: Resolved (was: Patch Available) [hive] lot of mappers due to a user error while specifying the partitioning column -- Key: HIVE-347 URL: https://issues.apache.org/jira/browse/HIVE-347 Project: Hadoop Hive Issue Type: Bug Components: Query Processor Reporter: Namit Jain Assignee: Namit Jain Fix For: 0.3.0 Attachments: hive.347.1.patch, hive.347.2.patch, hive.347.3.patch, hive.347.4.patch A common scenario when the table is partitioned on 'ds' column which is of type 'string' of a certain format '-mm-dd' However, if the user forgets to add quotes while specifying the query: select ... from T where ds = 2009-02-02 2009-02-02 is a valid integer expression. So, partition pruning makes all partitions unknown, since 2009-02-02 to double conversion is null. If all partitions are unknown, in strict mode, we should thrown an error -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
[jira] Updated: (HIVE-347) [hive] lot of mappers due to a user error while specifying the partitioning column
[ https://issues.apache.org/jira/browse/HIVE-347?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Namit Jain updated HIVE-347: Resolution: Fixed Fix Version/s: 0.3.0 Status: Resolved (was: Patch Available) committed. [hive] lot of mappers due to a user error while specifying the partitioning column -- Key: HIVE-347 URL: https://issues.apache.org/jira/browse/HIVE-347 Project: Hadoop Hive Issue Type: Bug Components: Query Processor Reporter: Namit Jain Assignee: Namit Jain Fix For: 0.3.0 Attachments: hive.347.1.patch, hive.347.2.patch, hive.347.3.patch A common scenario when the table is partitioned on 'ds' column which is of type 'string' of a certain format '-mm-dd' However, if the user forgets to add quotes while specifying the query: select ... from T where ds = 2009-02-02 2009-02-02 is a valid integer expression. So, partition pruning makes all partitions unknown, since 2009-02-02 to double conversion is null. If all partitions are unknown, in strict mode, we should thrown an error -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
[jira] Updated: (HIVE-347) [hive] lot of mappers due to a user error while specifying the partitioning column
[ https://issues.apache.org/jira/browse/HIVE-347?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Namit Jain updated HIVE-347: Status: Open (was: Patch Available) [hive] lot of mappers due to a user error while specifying the partitioning column -- Key: HIVE-347 URL: https://issues.apache.org/jira/browse/HIVE-347 Project: Hadoop Hive Issue Type: Bug Components: Query Processor Reporter: Namit Jain Assignee: Namit Jain Attachments: hive.347.1.patch A common scenario when the table is partitioned on 'ds' column which is of type 'string' of a certain format '-mm-dd' However, if the user forgets to add quotes while specifying the query: select ... from T where ds = 2009-02-02 2009-02-02 is a valid integer expression. So, partition pruning makes all partitions unknown, since 2009-02-02 to double conversion is null. If all partitions are unknown, in strict mode, we should thrown an error -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
[jira] Updated: (HIVE-347) [hive] lot of mappers due to a user error while specifying the partitioning column
[ https://issues.apache.org/jira/browse/HIVE-347?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Namit Jain updated HIVE-347: Status: Patch Available (was: Open) [hive] lot of mappers due to a user error while specifying the partitioning column -- Key: HIVE-347 URL: https://issues.apache.org/jira/browse/HIVE-347 Project: Hadoop Hive Issue Type: Bug Components: Query Processor Reporter: Namit Jain Assignee: Namit Jain Attachments: hive.347.1.patch, hive.347.2.patch A common scenario when the table is partitioned on 'ds' column which is of type 'string' of a certain format '-mm-dd' However, if the user forgets to add quotes while specifying the query: select ... from T where ds = 2009-02-02 2009-02-02 is a valid integer expression. So, partition pruning makes all partitions unknown, since 2009-02-02 to double conversion is null. If all partitions are unknown, in strict mode, we should thrown an error -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
[jira] Updated: (HIVE-347) [hive] lot of mappers due to a user error while specifying the partitioning column
[ https://issues.apache.org/jira/browse/HIVE-347?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Namit Jain updated HIVE-347: Attachment: hive.347.1.patch [hive] lot of mappers due to a user error while specifying the partitioning column -- Key: HIVE-347 URL: https://issues.apache.org/jira/browse/HIVE-347 Project: Hadoop Hive Issue Type: Bug Components: Query Processor Reporter: Namit Jain Assignee: Namit Jain Attachments: hive.347.1.patch A common scenario when the table is partitioned on 'ds' column which is of type 'string' of a certain format '-mm-dd' However, if the user forgets to add quotes while specifying the query: select ... from T where ds = 2009-02-02 2009-02-02 is a valid integer expression. So, partition pruning makes all partitions unknown, since 2009-02-02 to double conversion is null. If all partitions are unknown, in strict mode, we should thrown an error -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.