[jira] [Created] (HIVE-26186) Resultset returned by getTables does not order data per JDBC specification

2022-04-28 Thread N Campbell (Jira)
N Campbell created HIVE-26186: - Summary: Resultset returned by getTables does not order data per JDBC specification Key: HIVE-26186 URL: https://issues.apache.org/jira/browse/HIVE-26186 Project: Hive

[jira] [Created] (HIVE-25280) Hive standalone JAR packaging javamail.providers

2021-06-23 Thread N Campbell (Jira)
N Campbell created HIVE-25280: - Summary: Hive standalone JAR packaging javamail.providers Key: HIVE-25280 URL: https://issues.apache.org/jira/browse/HIVE-25280 Project: Hive Issue Type: Bug

[jira] [Created] (HIVE-24323) JDBC driver fails when using Kerberos due to missing dependencies

2020-10-28 Thread N Campbell (Jira)
N Campbell created HIVE-24323: - Summary: JDBC driver fails when using Kerberos due to missing dependencies Key: HIVE-24323 URL: https://issues.apache.org/jira/browse/HIVE-24323 Project: Hive

[jira] [Created] (HIVE-22134) Hive 3.1 driver includes org.glassfish.jersey.* which can interfer with an application

2019-08-21 Thread N Campbell (Jira)
N Campbell created HIVE-22134: - Summary: Hive 3.1 driver includes org.glassfish.jersey.* which can interfer with an application Key: HIVE-22134 URL: https://issues.apache.org/jira/browse/HIVE-22134

[jira] [Created] (HIVE-22129) Hive 3.1 standalone JAR includes Microsoft SQL Server JDBC driver

2019-08-20 Thread N Campbell (Jira)
N Campbell created HIVE-22129: - Summary: Hive 3.1 standalone JAR includes Microsoft SQL Server JDBC driver Key: HIVE-22129 URL: https://issues.apache.org/jira/browse/HIVE-22129 Project: Hive

[jira] [Created] (HIVE-15561) JDBC driver does not implement getArray method for array types

2017-01-08 Thread N Campbell (JIRA)
N Campbell created HIVE-15561: - Summary: JDBC driver does not implement getArray method for array types Key: HIVE-15561 URL: https://issues.apache.org/jira/browse/HIVE-15561 Project: Hive Issue

[jira] [Created] (HIVE-15553) expression to compute running sum fails with Failed to breakup Windowing invocations into Groups

2017-01-06 Thread N Campbell (JIRA)
N Campbell created HIVE-15553: - Summary: expression to compute running sum fails with Failed to breakup Windowing invocations into Groups Key: HIVE-15553 URL: https://issues.apache.org/jira/browse/HIVE-15553

[jira] [Created] (HIVE-15552) unable to coalesce DATE and TIMESTAMP types

2017-01-06 Thread N Campbell (JIRA)
N Campbell created HIVE-15552: - Summary: unable to coalesce DATE and TIMESTAMP types Key: HIVE-15552 URL: https://issues.apache.org/jira/browse/HIVE-15552 Project: Hive Issue Type: Bug

[jira] [Created] (HIVE-15548) TEZ exception error when NULL ordering specification used on cursor or window agg

2017-01-05 Thread N Campbell (JIRA)
N Campbell created HIVE-15548: - Summary: TEZ exception error when NULL ordering specification used on cursor or window agg Key: HIVE-15548 URL: https://issues.apache.org/jira/browse/HIVE-15548 Project:

[jira] [Created] (HIVE-15547) nulls not sorted last on cursor specification

2017-01-05 Thread N Campbell (JIRA)
N Campbell created HIVE-15547: - Summary: nulls not sorted last on cursor specification Key: HIVE-15547 URL: https://issues.apache.org/jira/browse/HIVE-15547 Project: Hive Issue Type: Bug

[jira] [Created] (HIVE-15545) JDBC driver aborts when DatabaseMetadata.getFunctions is called

2017-01-05 Thread N Campbell (JIRA)
N Campbell created HIVE-15545: - Summary: JDBC driver aborts when DatabaseMetadata.getFunctions is called Key: HIVE-15545 URL: https://issues.apache.org/jira/browse/HIVE-15545 Project: Hive

[jira] [Created] (HIVE-11377) currrent_timestamp in ISO-SQL is a timezone bearing type but Hive uses timezoneless types

2015-07-27 Thread N Campbell (JIRA)
N Campbell created HIVE-11377: - Summary: currrent_timestamp in ISO-SQL is a timezone bearing type but Hive uses timezoneless types Key: HIVE-11377 URL: https://issues.apache.org/jira/browse/HIVE-11377

[jira] [Created] (HIVE-11371) Null pointer exception for nested table query when using ORC versus text

2015-07-25 Thread N Campbell (JIRA)
N Campbell created HIVE-11371: - Summary: Null pointer exception for nested table query when using ORC versus text Key: HIVE-11371 URL: https://issues.apache.org/jira/browse/HIVE-11371 Project: Hive

[jira] [Created] (HIVE-11372) join with betwee predicate comparing integer types returns no rows when ORC format used

2015-07-25 Thread N Campbell (JIRA)
N Campbell created HIVE-11372: - Summary: join with betwee predicate comparing integer types returns no rows when ORC format used Key: HIVE-11372 URL: https://issues.apache.org/jira/browse/HIVE-11372

[jira] [Created] (HIVE-10936) incorrect result set when hive.vectorized.execution.enabled = true with predicate casting to CHAR or VARCHAR

2015-06-04 Thread N Campbell (JIRA)
N Campbell created HIVE-10936: - Summary: incorrect result set when hive.vectorized.execution.enabled = true with predicate casting to CHAR or VARCHAR Key: HIVE-10936 URL:

[jira] [Created] (HIVE-10488) cast DATE as TIMESTAMP returns incorrect values

2015-04-26 Thread N Campbell (JIRA)
N Campbell created HIVE-10488: - Summary: cast DATE as TIMESTAMP returns incorrect values Key: HIVE-10488 URL: https://issues.apache.org/jira/browse/HIVE-10488 Project: Hive Issue Type: Bug

[jira] [Created] (HIVE-10487) remove non-ISO restriction that projections in a union have identical column names

2015-04-25 Thread N Campbell (JIRA)
N Campbell created HIVE-10487: - Summary: remove non-ISO restriction that projections in a union have identical column names Key: HIVE-10487 URL: https://issues.apache.org/jira/browse/HIVE-10487 Project:

[jira] [Created] (HIVE-10282) Implement ISO-SQL substring semantics

2015-04-09 Thread N Campbell (JIRA)
N Campbell created HIVE-10282: - Summary: Implement ISO-SQL substring semantics Key: HIVE-10282 URL: https://issues.apache.org/jira/browse/HIVE-10282 Project: Hive Issue Type: Improvement

[jira] [Commented] (HIVE-9745) predicate evaluation of character fields with spaces and literals with spaces returns unexpected result

2015-02-21 Thread N Campbell (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9745?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14330279#comment-14330279 ] N Campbell commented on HIVE-9745: -- Turns out I added similar comments in 2013 to

[jira] [Created] (HIVE-9739) Quantified query fails with Tez/ORC file org.apache.hadoop.hive.ql.exec.tez.TezTask

2015-02-20 Thread N Campbell (JIRA)
N Campbell created HIVE-9739: Summary: Quantified query fails with Tez/ORC file org.apache.hadoop.hive.ql.exec.tez.TezTask Key: HIVE-9739 URL: https://issues.apache.org/jira/browse/HIVE-9739 Project:

[jira] [Commented] (HIVE-9537) string expressions on a fixed length character do not preserve trailing spaces

2015-02-20 Thread N Campbell (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9537?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14328992#comment-14328992 ] N Campbell commented on HIVE-9537: -- I saying that if the current implementation is by

[jira] [Commented] (HIVE-9735) aggregate ( smalllint ) fails when ORC file used ava.lang.ClassCastException: java.lang.Long cannot be cast to java.lang.Short

2015-02-20 Thread N Campbell (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9735?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14329533#comment-14329533 ] N Campbell commented on HIVE-9735: -- Using JDBC with SQLSquirrel aggregate ( smalllint )

[jira] [Updated] (HIVE-9739) Various queries fails with Tez/ORC file org.apache.hadoop.hive.ql.exec.tez.TezTask

2015-02-20 Thread N Campbell (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9739?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] N Campbell updated HIVE-9739: - Summary: Various queries fails with Tez/ORC file org.apache.hadoop.hive.ql.exec.tez.TezTask (was:

[jira] [Updated] (HIVE-9739) Various queries fails with Tez/ORC file org.apache.hadoop.hive.ql.exec.tez.TezTask due to Caused by: java.lang.ClassCastException

2015-02-20 Thread N Campbell (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9739?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] N Campbell updated HIVE-9739: - Summary: Various queries fails with Tez/ORC file org.apache.hadoop.hive.ql.exec.tez.TezTask due to Caused

[jira] [Created] (HIVE-9743) incorrect result set for left outer join when executed with tez versus mapreduce

2015-02-20 Thread N Campbell (JIRA)
N Campbell created HIVE-9743: Summary: incorrect result set for left outer join when executed with tez versus mapreduce Key: HIVE-9743 URL: https://issues.apache.org/jira/browse/HIVE-9743 Project: Hive

[jira] [Created] (HIVE-9745) predicate evaluation of character fields with spaces and literals with spaces returns unexpected result

2015-02-20 Thread N Campbell (JIRA)
N Campbell created HIVE-9745: Summary: predicate evaluation of character fields with spaces and literals with spaces returns unexpected result Key: HIVE-9745 URL: https://issues.apache.org/jira/browse/HIVE-9745

[jira] [Commented] (HIVE-9537) string expressions on a fixed length character do not preserve trailing spaces

2015-02-19 Thread N Campbell (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9537?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14327408#comment-14327408 ] N Campbell commented on HIVE-9537: -- I wouldn't suggest that use MySQL and Postgres alone

[jira] [Created] (HIVE-9734) Correlating expression cannot contain unqualified column references

2015-02-19 Thread N Campbell (JIRA)
N Campbell created HIVE-9734: Summary: Correlating expression cannot contain unqualified column references Key: HIVE-9734 URL: https://issues.apache.org/jira/browse/HIVE-9734 Project: Hive

[jira] [Created] (HIVE-9735) aggregate ( smalllint ) fails when ORC file used ava.lang.ClassCastException: java.lang.Long cannot be cast to java.lang.Short

2015-02-19 Thread N Campbell (JIRA)
N Campbell created HIVE-9735: Summary: aggregate ( smalllint ) fails when ORC file used ava.lang.ClassCastException: java.lang.Long cannot be cast to java.lang.Short Key: HIVE-9735 URL:

[jira] [Reopened] (HIVE-9537) string expressions on a fixed length character do not preserve trailing spaces

2015-02-18 Thread N Campbell (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9537?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] N Campbell reopened HIVE-9537: -- The Hive documentation is vague at best with respect to when padding is preserved/ignored: Char types are

[jira] [Created] (HIVE-9598) java.lang.IllegalMonitorStateException/java.util.concurrent.locks.ReentrantLock$Sync.tryRelease if ResultSet.closed called after Statement.close called

2015-02-06 Thread N Campbell (JIRA)
N Campbell created HIVE-9598: Summary: java.lang.IllegalMonitorStateException/java.util.concurrent.locks.ReentrantLock$Sync.tryRelease if ResultSet.closed called after Statement.close called Key: HIVE-9598 URL:

[jira] [Created] (HIVE-9535) add support for NULL ORDER specification in windowed aggregates

2015-01-31 Thread N Campbell (JIRA)
N Campbell created HIVE-9535: Summary: add support for NULL ORDER specification in windowed aggregates Key: HIVE-9535 URL: https://issues.apache.org/jira/browse/HIVE-9535 Project: Hive Issue

[jira] [Created] (HIVE-9530) constant * column is null interpreted as constant * boolean

2015-01-31 Thread N Campbell (JIRA)
N Campbell created HIVE-9530: Summary: constant * column is null interpreted as constant * boolean Key: HIVE-9530 URL: https://issues.apache.org/jira/browse/HIVE-9530 Project: Hive Issue Type:

[jira] [Created] (HIVE-9532) add support for quantified predicates

2015-01-31 Thread N Campbell (JIRA)
N Campbell created HIVE-9532: Summary: add support for quantified predicates Key: HIVE-9532 URL: https://issues.apache.org/jira/browse/HIVE-9532 Project: Hive Issue Type: Improvement

[jira] [Created] (HIVE-9531) remove requirement that EXISTS subquery must be correlated

2015-01-31 Thread N Campbell (JIRA)
N Campbell created HIVE-9531: Summary: remove requirement that EXISTS subquery must be correlated Key: HIVE-9531 URL: https://issues.apache.org/jira/browse/HIVE-9531 Project: Hive Issue Type:

[jira] [Created] (HIVE-9534) incorrect result set for query that projects a windowed aggregate

2015-01-31 Thread N Campbell (JIRA)
N Campbell created HIVE-9534: Summary: incorrect result set for query that projects a windowed aggregate Key: HIVE-9534 URL: https://issues.apache.org/jira/browse/HIVE-9534 Project: Hive Issue

[jira] [Created] (HIVE-9536) precision of a string concatenation becomes huge precision

2015-01-31 Thread N Campbell (JIRA)
N Campbell created HIVE-9536: Summary: precision of a string concatenation becomes huge precision Key: HIVE-9536 URL: https://issues.apache.org/jira/browse/HIVE-9536 Project: Hive Issue Type:

[jira] [Created] (HIVE-9537) string expressions on a fixed length character do not preserve trailing spaces

2015-01-31 Thread N Campbell (JIRA)
N Campbell created HIVE-9537: Summary: string expressions on a fixed length character do not preserve trailing spaces Key: HIVE-9537 URL: https://issues.apache.org/jira/browse/HIVE-9537 Project: Hive

[jira] [Created] (HIVE-9533) remove restriction that windowed aggregate ORDER BY can only have one key

2015-01-31 Thread N Campbell (JIRA)
N Campbell created HIVE-9533: Summary: remove restriction that windowed aggregate ORDER BY can only have one key Key: HIVE-9533 URL: https://issues.apache.org/jira/browse/HIVE-9533 Project: Hive

[jira] [Updated] (HIVE-9533) remove restriction that windowed aggregate ORDER BY can only have one key

2015-01-31 Thread N Campbell (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9533?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] N Campbell updated HIVE-9533: - Component/s: SQL remove restriction that windowed aggregate ORDER BY can only have one key

[jira] [Commented] (HIVE-3245) UTF encoded data not displayed correctly by Hive driver

2013-12-07 Thread N Campbell (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3245?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13842258#comment-13842258 ] N Campbell commented on HIVE-3245: -- Re the prior comment. If encoding information has to

[jira] [Commented] (HIVE-4662) first_value can't have more than one order by column

2013-10-13 Thread N Campbell (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4662?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13793651#comment-13793651 ] N Campbell commented on HIVE-4662: -- That is a fairly significant limitation. first_value

[jira] [Commented] (HIVE-4662) first_value can't have more than one order by column

2013-10-13 Thread N Campbell (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4662?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13793652#comment-13793652 ] N Campbell commented on HIVE-4662: -- not just first value select c1, c2, sum ( c3 ) over (

[jira] [Commented] (HIVE-3745) Hive does improper = based string comparisons for strings with trailing whitespaces

2013-10-13 Thread N Campbell (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3745?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13793658#comment-13793658 ] N Campbell commented on HIVE-3745: -- The ISO-SQL standard is very clear as to what a vendor

[jira] [Created] (HIVE-5529) precision and scale for DECIMAL type p=2147483647 s=2147483647

2013-10-12 Thread N Campbell (JIRA)
N Campbell created HIVE-5529: Summary: precision and scale for DECIMAL type p=2147483647 s=2147483647 Key: HIVE-5529 URL: https://issues.apache.org/jira/browse/HIVE-5529 Project: Hive Issue

[jira] [Commented] (HIVE-3173) implement getTypeInfo database metadata method

2013-10-12 Thread N Campbell (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3173?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13793491#comment-13793491 ] N Campbell commented on HIVE-3173: -- Hive 0.11 fails to define prefix and suffix

[jira] [Created] (HIVE-5530) null pointer exception when case returns null

2013-10-12 Thread N Campbell (JIRA)
N Campbell created HIVE-5530: Summary: null pointer exception when case returns null Key: HIVE-5530 URL: https://issues.apache.org/jira/browse/HIVE-5530 Project: Hive Issue Type: Bug

[jira] [Commented] (HIVE-5473) sqrt of -ve value returns null instead of throwing an error

2013-10-07 Thread N Campbell (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5473?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13788638#comment-13788638 ] N Campbell commented on HIVE-5473: -- other cases are select 0 / 0 from tversion select

[jira] [Created] (HIVE-5460) invalid offsets in lag lead should return an exception (per ISO-SQL)

2013-10-06 Thread N Campbell (JIRA)
N Campbell created HIVE-5460: Summary: invalid offsets in lag lead should return an exception (per ISO-SQL) Key: HIVE-5460 URL: https://issues.apache.org/jira/browse/HIVE-5460 Project: Hive

[jira] [Created] (HIVE-5461) lag lead do not offer ISO-SQL 2012 null treatment

2013-10-06 Thread N Campbell (JIRA)
N Campbell created HIVE-5461: Summary: lag lead do not offer ISO-SQL 2012 null treatment Key: HIVE-5461 URL: https://issues.apache.org/jira/browse/HIVE-5461 Project: Hive Issue Type:

[jira] [Created] (HIVE-5462) improve error when an approximate numeric literal provided to lag lead

2013-10-06 Thread N Campbell (JIRA)
N Campbell created HIVE-5462: Summary: improve error when an approximate numeric literal provided to lag lead Key: HIVE-5462 URL: https://issues.apache.org/jira/browse/HIVE-5462 Project: Hive

[jira] [Created] (HIVE-5463) support hypothetical ranking aggregates

2013-10-06 Thread N Campbell (JIRA)
N Campbell created HIVE-5463: Summary: support hypothetical ranking aggregates Key: HIVE-5463 URL: https://issues.apache.org/jira/browse/HIVE-5463 Project: Hive Issue Type: Improvement

[jira] [Created] (HIVE-5464) allow OR conditions in table join

2013-10-06 Thread N Campbell (JIRA)
N Campbell created HIVE-5464: Summary: allow OR conditions in table join Key: HIVE-5464 URL: https://issues.apache.org/jira/browse/HIVE-5464 Project: Hive Issue Type: Improvement Affects

[jira] [Created] (HIVE-5465) unable to express nested join

2013-10-06 Thread N Campbell (JIRA)
N Campbell created HIVE-5465: Summary: unable to express nested join Key: HIVE-5465 URL: https://issues.apache.org/jira/browse/HIVE-5465 Project: Hive Issue Type: Bug Affects Versions:

[jira] [Created] (HIVE-5466) add support for table and row constructors in a statement

2013-10-06 Thread N Campbell (JIRA)
N Campbell created HIVE-5466: Summary: add support for table and row constructors in a statement Key: HIVE-5466 URL: https://issues.apache.org/jira/browse/HIVE-5466 Project: Hive Issue Type:

[jira] [Commented] (HIVE-5460) invalid offsets in lag lead should return an exception (per ISO-SQL)

2013-10-06 Thread N Campbell (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5460?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13787673#comment-13787673 ] N Campbell commented on HIVE-5460: -- You would need to go to the ISO web site

[jira] [Updated] (HIVE-5460) invalid offsets in lag lead should return an exception (per ISO-SQL)

2013-10-06 Thread N Campbell (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5460?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] N Campbell updated HIVE-5460: - Description: ISO-SQL 2011 defines how lag and lead should behave when invalid offsets are provided to

[jira] [Created] (HIVE-5467) allow null ordering specification in a windowed aggregate

2013-10-06 Thread N Campbell (JIRA)
N Campbell created HIVE-5467: Summary: allow null ordering specification in a windowed aggregate Key: HIVE-5467 URL: https://issues.apache.org/jira/browse/HIVE-5467 Project: Hive Issue Type:

[jira] [Created] (HIVE-5468) allow null ordering to be defined on cursor specification

2013-10-06 Thread N Campbell (JIRA)
N Campbell created HIVE-5468: Summary: allow null ordering to be defined on cursor specification Key: HIVE-5468 URL: https://issues.apache.org/jira/browse/HIVE-5468 Project: Hive Issue Type:

[jira] [Created] (HIVE-5469) support nullif

2013-10-06 Thread N Campbell (JIRA)
N Campbell created HIVE-5469: Summary: support nullif Key: HIVE-5469 URL: https://issues.apache.org/jira/browse/HIVE-5469 Project: Hive Issue Type: Improvement Affects Versions: 0.11.0

[jira] [Updated] (HIVE-3194) implement the JDBC canonical/ISO-SQL 2011 scalar functions

2013-10-06 Thread N Campbell (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3194?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] N Campbell updated HIVE-3194: - Summary: implement the JDBC canonical/ISO-SQL 2011 scalar functions (was: implement the JDBC

[jira] [Updated] (HIVE-5461) lag lead do not offer ISO-SQL 2011 null treatment

2013-10-06 Thread N Campbell (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5461?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] N Campbell updated HIVE-5461: - Summary: lag lead do not offer ISO-SQL 2011 null treatment (was: lag lead do not offer ISO-SQL 2012

[jira] [Updated] (HIVE-3188) allow cast to use double precision per ISO-SQL 2011

2013-10-06 Thread N Campbell (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3188?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] N Campbell updated HIVE-3188: - Summary: allow cast to use double precision per ISO-SQL 2011 (was: allow cast to use double precision

[jira] [Updated] (HIVE-3190) allow INTEGER as a type name in a column/cast expression (per ISO-SQL 2011)

2013-10-06 Thread N Campbell (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3190?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] N Campbell updated HIVE-3190: - Summary: allow INTEGER as a type name in a column/cast expression (per ISO-SQL 2011) (was: allow INTEGER

[jira] [Updated] (HIVE-3184) remove existing restriction that union must be defined within a derived table (follow ISO-SQL 2011)

2013-10-06 Thread N Campbell (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3184?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] N Campbell updated HIVE-3184: - Summary: remove existing restriction that union must be defined within a derived table (follow ISO-SQL

[jira] [Updated] (HIVE-3185) allow union set operation without ALL keyword (align to ISO-SQL 2011 specification)

2013-10-06 Thread N Campbell (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3185?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] N Campbell updated HIVE-3185: - Summary: allow union set operation without ALL keyword (align to ISO-SQL 2011 specification) (was: allow

[jira] [Updated] (HIVE-3186) support having without a grouping operation (per ISO-SQL 2011)

2013-10-06 Thread N Campbell (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3186?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] N Campbell updated HIVE-3186: - Summary: support having without a grouping operation (per ISO-SQL 2011) (was: support having without a

[jira] [Created] (HIVE-5470) support extract function

2013-10-06 Thread N Campbell (JIRA)
N Campbell created HIVE-5470: Summary: support extract function Key: HIVE-5470 URL: https://issues.apache.org/jira/browse/HIVE-5470 Project: Hive Issue Type: Improvement Affects Versions:

[jira] [Created] (HIVE-5471) allow timestamp literal per ISO-SQL

2013-10-06 Thread N Campbell (JIRA)
N Campbell created HIVE-5471: Summary: allow timestamp literal per ISO-SQL Key: HIVE-5471 URL: https://issues.apache.org/jira/browse/HIVE-5471 Project: Hive Issue Type: Improvement Affects

[jira] [Created] (HIVE-5472) support a simple scalar which returns the current timestamp

2013-10-06 Thread N Campbell (JIRA)
N Campbell created HIVE-5472: Summary: support a simple scalar which returns the current timestamp Key: HIVE-5472 URL: https://issues.apache.org/jira/browse/HIVE-5472 Project: Hive Issue Type:

[jira] [Commented] (HIVE-3183) case expression should allow different types per ISO-SQL 2011

2013-10-06 Thread N Campbell (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3183?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13787715#comment-13787715 ] N Campbell commented on HIVE-3183: -- I am not planning to commit code changes to Apache.

[jira] [Created] (HIVE-5473) sqrt of -ve value returns null instead of throwing an error

2013-10-06 Thread N Campbell (JIRA)
N Campbell created HIVE-5473: Summary: sqrt of -ve value returns null instead of throwing an error Key: HIVE-5473 URL: https://issues.apache.org/jira/browse/HIVE-5473 Project: Hive Issue Type:

[jira] [Commented] (HIVE-3121) JDBC driver's getCatalogs() method returns schema/db information

2013-07-03 Thread N Campbell (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3121?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13699651#comment-13699651 ] N Campbell commented on HIVE-3121: -- does this mean that getTables will work correctly now

[jira] [Commented] (HIVE-4573) JDBC Compliance getTables

2013-07-03 Thread N Campbell (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4573?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13699670#comment-13699670 ] N Campbell commented on HIVE-4573: -- while it is true that getTableTypes lists the types

[jira] [Commented] (HIVE-4256) JDBC2 HiveConnection does not use the specified database

2013-07-03 Thread N Campbell (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4256?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13699675#comment-13699675 ] N Campbell commented on HIVE-4256: -- we have seen 'similar' issues with Hive 0.8, 0.9 and

[jira] [Commented] (HIVE-3176) implement returning values for SQLException getSQLState()

2013-05-07 Thread N Campbell (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3176?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13650764#comment-13650764 ] N Campbell commented on HIVE-3176: -- I'd expect the Hive driver to align to the JDBC 3.x or

[jira] [Created] (HIVE-3245) UTF encoded data not displayed correctly by Hive driver

2012-07-09 Thread N Campbell (JIRA)
N Campbell created HIVE-3245: Summary: UTF encoded data not displayed correctly by Hive driver Key: HIVE-3245 URL: https://issues.apache.org/jira/browse/HIVE-3245 Project: Hive Issue Type: Bug

[jira] [Updated] (HIVE-3245) UTF encoded data not displayed correctly by Hive driver

2012-07-09 Thread N Campbell (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3245?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] N Campbell updated HIVE-3245: - Attachment: CERT.TLJA.txt example JP data UTF encoded data not displayed correctly by

[jira] [Updated] (HIVE-3245) UTF encoded data not displayed correctly by Hive driver

2012-07-09 Thread N Campbell (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3245?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] N Campbell updated HIVE-3245: - Description: various foreign language data (i.e. japanese, thai etc) is loaded into string columns via

[jira] [Updated] (HIVE-3245) UTF encoded data not displayed correctly by Hive driver

2012-07-09 Thread N Campbell (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3245?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] N Campbell updated HIVE-3245: - Attachment: screenshot-1.jpg example of test shown in SQLSquirrel UTF encoded data not

[jira] [Created] (HIVE-3239) exception will be thrown for timestamp column in resultset from getColumns metadata method

2012-07-06 Thread N Campbell (JIRA)
N Campbell created HIVE-3239: Summary: exception will be thrown for timestamp column in resultset from getColumns metadata method Key: HIVE-3239 URL: https://issues.apache.org/jira/browse/HIVE-3239

[jira] [Updated] (HIVE-3239) exception will be thrown for timestamp column in resultset from getColumns metadata method

2012-07-06 Thread N Campbell (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3239?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] N Campbell updated HIVE-3239: - Component/s: JDBC Affects Version/s: 0.8.1 exception will be thrown for timestamp column

[jira] [Commented] (HIVE-3216) DateDiff UDF overload with a unit parameter

2012-07-05 Thread N Campbell (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3216?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13407002#comment-13407002 ] N Campbell commented on HIVE-3216: -- Note, ISO-SQL does not have DateDiff rather timestamp

[jira] [Created] (HIVE-3228) unable to load null values that represent a timestamp value

2012-07-05 Thread N Campbell (JIRA)
N Campbell created HIVE-3228: Summary: unable to load null values that represent a timestamp value Key: HIVE-3228 URL: https://issues.apache.org/jira/browse/HIVE-3228 Project: Hive Issue Type:

[jira] [Updated] (HIVE-3228) unable to load null values that represent a timestamp value

2012-07-05 Thread N Campbell (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3228?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] N Campbell updated HIVE-3228: - Attachment: CERT.TTS.txt input data file using tab delimited columns unable to load

[jira] [Created] (HIVE-3229) null values being loaded as non-null values into Hive

2012-07-05 Thread N Campbell (JIRA)
N Campbell created HIVE-3229: Summary: null values being loaded as non-null values into Hive Key: HIVE-3229 URL: https://issues.apache.org/jira/browse/HIVE-3229 Project: Hive Issue Type: Bug

[jira] [Updated] (HIVE-3229) null values being loaded as non-null values into Hive

2012-07-05 Thread N Campbell (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3229?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] N Campbell updated HIVE-3229: - Attachment: CERT.TSET1.txt One example null values being loaded as non-null values into

[jira] [Updated] (HIVE-3229) null values being loaded as non-null values into Hive

2012-07-05 Thread N Campbell (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3229?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] N Campbell updated HIVE-3229: - Description: various tab delimited input files contain one or more columns that represent null values in

[jira] [Commented] (HIVE-2703) ResultSetMetaData.getColumnType() always returns VARCHAR(string) for partition columns irrespective of partition column type

2012-06-28 Thread N Campbell (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2703?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13403048#comment-13403048 ] N Campbell commented on HIVE-2703: -- Is this fix (or any other) addressing similar issues

[jira] [Created] (HIVE-3196) date_add of a timestamp returning a string representation of the date portion

2012-06-25 Thread N Campbell (JIRA)
N Campbell created HIVE-3196: Summary: date_add of a timestamp returning a string representation of the date portion Key: HIVE-3196 URL: https://issues.apache.org/jira/browse/HIVE-3196 Project: Hive

[jira] [Created] (HIVE-3183) case expression should allow different types per ISO-SQL 2012

2012-06-24 Thread N Campbell (JIRA)
N Campbell created HIVE-3183: Summary: case expression should allow different types per ISO-SQL 2012 Key: HIVE-3183 URL: https://issues.apache.org/jira/browse/HIVE-3183 Project: Hive Issue

[jira] [Created] (HIVE-3184) remove existing restriction that union must be defined within a derived table (follow ISO-SQL 2012)

2012-06-24 Thread N Campbell (JIRA)
N Campbell created HIVE-3184: Summary: remove existing restriction that union must be defined within a derived table (follow ISO-SQL 2012) Key: HIVE-3184 URL: https://issues.apache.org/jira/browse/HIVE-3184

[jira] [Created] (HIVE-3185) allow union set operation without ALL keyword (align to ISO-SQL 2012 specification)

2012-06-24 Thread N Campbell (JIRA)
N Campbell created HIVE-3185: Summary: allow union set operation without ALL keyword (align to ISO-SQL 2012 specification) Key: HIVE-3185 URL: https://issues.apache.org/jira/browse/HIVE-3185 Project:

[jira] [Created] (HIVE-3186) support having without a grouping operation (per ISO-SQL 2012)

2012-06-24 Thread N Campbell (JIRA)
N Campbell created HIVE-3186: Summary: support having without a grouping operation (per ISO-SQL 2012) Key: HIVE-3186 URL: https://issues.apache.org/jira/browse/HIVE-3186 Project: Hive Issue

[jira] [Created] (HIVE-3187) support ISO-2012 timestamp literals

2012-06-24 Thread N Campbell (JIRA)
N Campbell created HIVE-3187: Summary: support ISO-2012 timestamp literals Key: HIVE-3187 URL: https://issues.apache.org/jira/browse/HIVE-3187 Project: Hive Issue Type: Improvement Affects

[jira] [Created] (HIVE-3188) allow cast to use double precision per ISO-SQL 2012

2012-06-24 Thread N Campbell (JIRA)
N Campbell created HIVE-3188: Summary: allow cast to use double precision per ISO-SQL 2012 Key: HIVE-3188 URL: https://issues.apache.org/jira/browse/HIVE-3188 Project: Hive Issue Type:

[jira] [Created] (HIVE-3189) cast ( string type as bigint) returning null values

2012-06-24 Thread N Campbell (JIRA)
N Campbell created HIVE-3189: Summary: cast ( string type as bigint) returning null values Key: HIVE-3189 URL: https://issues.apache.org/jira/browse/HIVE-3189 Project: Hive Issue Type: Bug

[jira] [Created] (HIVE-3190) allow INTEGER as a type name in a column/cast expression (per ISO-SQL 2012)

2012-06-24 Thread N Campbell (JIRA)
N Campbell created HIVE-3190: Summary: allow INTEGER as a type name in a column/cast expression (per ISO-SQL 2012) Key: HIVE-3190 URL: https://issues.apache.org/jira/browse/HIVE-3190 Project: Hive

[jira] [Created] (HIVE-3192) between predicate parsing issues

2012-06-24 Thread N Campbell (JIRA)
N Campbell created HIVE-3192: Summary: between predicate parsing issues Key: HIVE-3192 URL: https://issues.apache.org/jira/browse/HIVE-3192 Project: Hive Issue Type: Bug Affects Versions:

[jira] [Created] (HIVE-3193) cannot query views using qualified table references

2012-06-24 Thread N Campbell (JIRA)
N Campbell created HIVE-3193: Summary: cannot query views using qualified table references Key: HIVE-3193 URL: https://issues.apache.org/jira/browse/HIVE-3193 Project: Hive Issue Type: Bug

  1   2   >