[jira] [Updated] (HIVE-2075) error in function count(distinct col)
[ https://issues.apache.org/jira/browse/HIVE-2075?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexey Diomin updated HIVE-2075: Description: select N.cl1, count(distinct N.cl2) as cl2count, N.cl3 from raw N group by N.cl1, N.cl2, N.cl3 not working on 0.7 (on 0.6 work correct), but count(N.cl2) work correct was: select N.cl1, count(distinct N.cl2) as cl2count, N.cl3 from raw N group by N.cl1, N.cl2, N.cl3 not working on 0.7 (on 0.6 work correct), but count(distinct N.cl2) work correct error in function count(distinct col) -- Key: HIVE-2075 URL: https://issues.apache.org/jira/browse/HIVE-2075 Project: Hive Issue Type: Bug Components: Query Processor, Serializers/Deserializers Affects Versions: 0.7.0 Reporter: Alexey Diomin select N.cl1, count(distinct N.cl2) as cl2count, N.cl3 from raw N group by N.cl1, N.cl2, N.cl3 not working on 0.7 (on 0.6 work correct), but count(N.cl2) work correct -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (HIVE-2063) jdbc return only 1 collumn
[ https://issues.apache.org/jira/browse/HIVE-2063?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13009623#comment-13009623 ] Alexey Diomin commented on HIVE-2063: - wait bug very interesting reproducing on hadoop-0.20.2, but on cloudera CDH3B4 bug not reproducing and apply patch break correct parsing input row, as delimiter in input row is have code '1' (default) jdbc return only 1 collumn -- Key: HIVE-2063 URL: https://issues.apache.org/jira/browse/HIVE-2063 Project: Hive Issue Type: Bug Components: JDBC Affects Versions: 0.7.0 Reporter: Alexey Diomin Assignee: Alexey Diomin Priority: Critical Attachments: HIVE-2063.patch, HIVE-2063.patch we not set separator for data and all data return in first columns and all other fields set NULL addition we get WARNING: Missing fields! Expected 27 fields but only got 1! Ignoring similar problems. it's regresion after HIVE-1378 bug: use delimiter '\t' for fields on server side use default delimiter with code '1' on client side -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Updated: (HIVE-2063) jdbc return only 1 collumn
[ https://issues.apache.org/jira/browse/HIVE-2063?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexey Diomin updated HIVE-2063: Status: Patch Available (was: Open) jdbc return only 1 collumn -- Key: HIVE-2063 URL: https://issues.apache.org/jira/browse/HIVE-2063 Project: Hive Issue Type: Bug Components: JDBC Affects Versions: 0.7.0 Reporter: Alexey Diomin Priority: Critical Attachments: HIVE-2063.patch, HIVE-2063.patch we not set separator for data and all data return in first columns and all other fields set NULL addition we get WARNING: Missing fields! Expected 27 fields but only got 1! Ignoring similar problems. it's regresion after HIVE-1378 bug: use delimiter '\t' for fields on server side use default delimiter with code '1' on client side -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Updated: (HIVE-2063) jdbc return only 1 collumn
[ https://issues.apache.org/jira/browse/HIVE-2063?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexey Diomin updated HIVE-2063: Attachment: HIVE-2063.patch jdbc return only 1 collumn -- Key: HIVE-2063 URL: https://issues.apache.org/jira/browse/HIVE-2063 Project: Hive Issue Type: Bug Components: JDBC Affects Versions: 0.7.0 Reporter: Alexey Diomin Priority: Critical Attachments: HIVE-2063.patch, HIVE-2063.patch we not set separator for data and all data return in first columns and all other fields set NULL addition we get WARNING: Missing fields! Expected 27 fields but only got 1! Ignoring similar problems. it's regresion after HIVE-1378 bug: use delimiter '\t' for fields on server side use default delimiter with code '1' on client side -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Created: (HIVE-2062) HivePreparedStatement.executeImmediate always throw exception
HivePreparedStatement.executeImmediate always throw exception - Key: HIVE-2062 URL: https://issues.apache.org/jira/browse/HIVE-2062 Project: Hive Issue Type: Bug Components: JDBC Affects Versions: 0.7.0 Reporter: Alexey Diomin Priority: Critical executeImmediate: try { clearWarnings(); resultSet = null; client.execute(sql); } but: public void clearWarnings() throws SQLException { // TODO Auto-generated method stub throw new SQLException(Method not supported); } in result all calls executeQuery() for prepared statement return exception -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Updated: (HIVE-2062) HivePreparedStatement.executeImmediate always throw exception
[ https://issues.apache.org/jira/browse/HIVE-2062?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexey Diomin updated HIVE-2062: Assignee: Alexey Diomin Status: Patch Available (was: Open) HivePreparedStatement.executeImmediate always throw exception - Key: HIVE-2062 URL: https://issues.apache.org/jira/browse/HIVE-2062 Project: Hive Issue Type: Bug Components: JDBC Affects Versions: 0.7.0 Reporter: Alexey Diomin Assignee: Alexey Diomin Priority: Critical Attachments: HIVE-2062.patch executeImmediate: try { clearWarnings(); resultSet = null; client.execute(sql); } but: public void clearWarnings() throws SQLException { // TODO Auto-generated method stub throw new SQLException(Method not supported); } in result all calls executeQuery() for prepared statement return exception -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Updated: (HIVE-2062) HivePreparedStatement.executeImmediate always throw exception
[ https://issues.apache.org/jira/browse/HIVE-2062?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexey Diomin updated HIVE-2062: Attachment: HIVE-2062.patch HivePreparedStatement.executeImmediate always throw exception - Key: HIVE-2062 URL: https://issues.apache.org/jira/browse/HIVE-2062 Project: Hive Issue Type: Bug Components: JDBC Affects Versions: 0.7.0 Reporter: Alexey Diomin Priority: Critical Attachments: HIVE-2062.patch executeImmediate: try { clearWarnings(); resultSet = null; client.execute(sql); } but: public void clearWarnings() throws SQLException { // TODO Auto-generated method stub throw new SQLException(Method not supported); } in result all calls executeQuery() for prepared statement return exception -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Created: (HIVE-2063) jdbc return only 1 collumn
jdbc return only 1 collumn -- Key: HIVE-2063 URL: https://issues.apache.org/jira/browse/HIVE-2063 Project: Hive Issue Type: Bug Components: JDBC Affects Versions: 0.7.0 Reporter: Alexey Diomin Priority: Critical Attachments: HIVE-2063.patch we not set separator for data and all data return in first columns and all other fields set NULL addition we get WARNING: Missing fields! Expected 27 fields but only got 1! Ignoring similar problems. it's regresion after HIVE-1378 bug: use delimiter '\t' for fields on server side use default delimiter with code '1' on client side -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Updated: (HIVE-2063) jdbc return only 1 collumn
[ https://issues.apache.org/jira/browse/HIVE-2063?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexey Diomin updated HIVE-2063: Attachment: HIVE-2063.patch jdbc return only 1 collumn -- Key: HIVE-2063 URL: https://issues.apache.org/jira/browse/HIVE-2063 Project: Hive Issue Type: Bug Components: JDBC Affects Versions: 0.7.0 Reporter: Alexey Diomin Priority: Critical Attachments: HIVE-2063.patch we not set separator for data and all data return in first columns and all other fields set NULL addition we get WARNING: Missing fields! Expected 27 fields but only got 1! Ignoring similar problems. it's regresion after HIVE-1378 bug: use delimiter '\t' for fields on server side use default delimiter with code '1' on client side -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Updated: (HIVE-2063) jdbc return only 1 collumn
[ https://issues.apache.org/jira/browse/HIVE-2063?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexey Diomin updated HIVE-2063: Status: Patch Available (was: Open) jdbc return only 1 collumn -- Key: HIVE-2063 URL: https://issues.apache.org/jira/browse/HIVE-2063 Project: Hive Issue Type: Bug Components: JDBC Affects Versions: 0.7.0 Reporter: Alexey Diomin Priority: Critical Attachments: HIVE-2063.patch we not set separator for data and all data return in first columns and all other fields set NULL addition we get WARNING: Missing fields! Expected 27 fields but only got 1! Ignoring similar problems. it's regresion after HIVE-1378 bug: use delimiter '\t' for fields on server side use default delimiter with code '1' on client side -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira