[jira] [Commented] (HIVE-21117) A day may belong to a different year than the week it is a part of

2019-01-14 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-21117?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16742670#comment-16742670 ] Carter Shanklin commented on HIVE-21117: Postgres uses extract(isoyear from date)

[jira] [Commented] (HIVE-16944) schematool -dbType hive should give some more feedback/assistance

2018-04-10 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-16944?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16432349#comment-16432349 ] Carter Shanklin commented on HIVE-16944: [~bharos92] I'm not working with Hive the

[jira] [Commented] (HIVE-17869) unix_timestamp(string date, string pattern) UDF does not verify date is valid

2017-10-23 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17869?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16215532#comment-16215532 ] Carter Shanklin commented on HIVE-17869: Seems to be the same as HIVE-17038 which

[jira] [Resolved] (HIVE-10780) Support INTERSECTION set operation

2017-08-10 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10780?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carter Shanklin resolved HIVE-10780. Resolution: Duplicate This was handled in HIVE-12764 Resolving because it was causing some

[jira] [Commented] (HIVE-17135) Bad error messages when beeline connects to unreachable hosts using binary and SSL

2017-07-20 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17135?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16094887#comment-16094887 ] Carter Shanklin commented on HIVE-17135: One more problem: Connection Refused is a

[jira] [Updated] (HIVE-17136) Unhelpful beeline error message when you attempt to connect to HTTP HS2 using binary with SSL enabled

2017-07-20 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17136?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carter Shanklin updated HIVE-17136: --- Description: In this case the error message is "Invalid status 72". Full error: Error: Could

[jira] [Updated] (HIVE-17136) Unhelpful beeline error message when you attempt to connect to HTTP HS2 using binary with SSL enabled

2017-07-20 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17136?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carter Shanklin updated HIVE-17136: --- Component/s: Beeline > Unhelpful beeline error message when you attempt to connect to HTTP HS2

[jira] [Updated] (HIVE-17135) Bad error messages when beeline connects to unreachable hosts using binary and SSL

2017-07-20 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17135?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carter Shanklin updated HIVE-17135: --- Attachment: Screen Shot 2017-07-20 at 08.42.07.png > Bad error messages when beeline connects

[jira] [Commented] (HIVE-17018) Small table is converted to map join even the total size of small tables exceeds the threshold(hive.auto.convert.join.noconditionaltask.size)

2017-07-15 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17018?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16088721#comment-16088721 ] Carter Shanklin commented on HIVE-17018: My inputs: That particular variable can'

[jira] [Commented] (HIVE-10924) add support for MERGE statement

2017-07-07 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10924?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16078708#comment-16078708 ] Carter Shanklin commented on HIVE-10924: [~Absolutesantaja] that's a good call out

[jira] [Comment Edited] (HIVE-17013) Delete request with a subquery based on select over a view

2017-07-04 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17013?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16073900#comment-16073900 ] Carter Shanklin edited comment on HIVE-17013 at 7/4/17 4:43 PM:

[jira] [Comment Edited] (HIVE-17013) Delete request with a subquery based on select over a view

2017-07-04 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17013?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16073900#comment-16073900 ] Carter Shanklin edited comment on HIVE-17013 at 7/4/17 4:41 PM:

[jira] [Commented] (HIVE-17013) Delete request with a subquery based on select over a view

2017-07-04 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17013?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16073900#comment-16073900 ] Carter Shanklin commented on HIVE-17013: [~ekoifman] I'm seeing this as well. Od

[jira] [Commented] (HIVE-16496) Enhance asterisk expression (as in "select *") with EXCLUDE clause

2017-06-29 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-16496?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16068556#comment-16068556 ] Carter Shanklin commented on HIVE-16496: Ran across this today: https://stackover

[jira] [Commented] (HIVE-6348) Order by/Sort by in subquery

2017-06-28 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-6348?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16067709#comment-16067709 ] Carter Shanklin commented on HIVE-6348: --- It's trivia at this point but ORDER BY in su

[jira] [Comment Edited] (HIVE-16434) Add support for parsing additional timestamp formats

2017-06-25 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-16434?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16062447#comment-16062447 ] Carter Shanklin edited comment on HIVE-16434 at 6/25/17 10:33 PM: --

[jira] [Commented] (HIVE-16434) Add support for parsing additional timestamp formats

2017-06-25 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-16434?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16062447#comment-16062447 ] Carter Shanklin commented on HIVE-16434: SQL:2016 adds parsing templates and a for

[jira] [Commented] (HIVE-16944) schematool -dbType hive should give some more feedback/assistance

2017-06-22 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-16944?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16059560#comment-16059560 ] Carter Shanklin commented on HIVE-16944: Also [~vihangk1] if you're interested in

[jira] [Commented] (HIVE-16944) schematool -dbType hive should give some more feedback/assistance

2017-06-22 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-16944?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16059557#comment-16059557 ] Carter Shanklin commented on HIVE-16944: The dbType hive is specifically for the n

[jira] [Commented] (HIVE-16648) Allow select distinct with group by

2017-06-22 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-16648?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16059504#comment-16059504 ] Carter Shanklin commented on HIVE-16648: To clarify I wasn't looking for a workaro

[jira] [Commented] (HIVE-16927) LLAP: Slider takes down all daemons when some daemons fail repeatedly

2017-06-21 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-16927?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16058239#comment-16058239 ] Carter Shanklin commented on HIVE-16927: [~sershe] [~prasanth_j] probably makes se

[jira] [Commented] (HIVE-16829) A multiline/pretty-print JSON Data Record Reader

2017-06-06 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-16829?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16039160#comment-16039160 ] Carter Shanklin commented on HIVE-16829: This would be great to see (I see the tic

[jira] [Commented] (HIVE-6348) Order by/Sort by in subquery

2017-06-05 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-6348?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16037458#comment-16037458 ] Carter Shanklin commented on HIVE-6348: --- I don't think banning is a good idea, there'

[jira] [Commented] (HIVE-16789) Query with window function fails when where clause returns no records

2017-06-02 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-16789?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16034806#comment-16034806 ] Carter Shanklin commented on HIVE-16789: There's also a 2.1.1 release which may so

[jira] [Commented] (HIVE-16789) Query with window function fails when where clause returns no records

2017-06-01 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-16789?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16033094#comment-16033094 ] Carter Shanklin commented on HIVE-16789: This doesn't reproduce on HDP 2.5.3 (vers

[jira] [Commented] (HIVE-16789) Query with window function fails when where clause returns no records

2017-05-31 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-16789?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16031135#comment-16031135 ] Carter Shanklin commented on HIVE-16789: Does the error occur when using Tez inste

[jira] [Comment Edited] (HIVE-16789) Query with window function fails when where clause returns no records

2017-05-31 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-16789?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16031135#comment-16031135 ] Carter Shanklin edited comment on HIVE-16789 at 5/31/17 1:18 PM: ---

[jira] [Updated] (HIVE-16258) Suggestion: simplify type 2 SCDs with this non-standard extension to MERGE

2017-05-30 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-16258?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carter Shanklin updated HIVE-16258: --- Summary: Suggestion: simplify type 2 SCDs with this non-standard extension to MERGE (was: Sug

[jira] [Commented] (HIVE-16763) Support space in quoted column alias

2017-05-25 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-16763?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16025790#comment-16025790 ] Carter Shanklin commented on HIVE-16763: If we're considering adding double-quoted

[jira] [Resolved] (HIVE-16695) beeline throws ArrayIndexOutOfBoundsException sourcing multiple multi-line queries

2017-05-22 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-16695?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carter Shanklin resolved HIVE-16695. Resolution: Cannot Reproduce > beeline throws ArrayIndexOutOfBoundsException sourcing multip

[jira] [Commented] (HIVE-16695) beeline throws ArrayIndexOutOfBoundsException sourcing multiple multi-line queries

2017-05-22 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-16695?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16020615#comment-16020615 ] Carter Shanklin commented on HIVE-16695: I'm unable to repro the issue now after t

[jira] [Commented] (HIVE-16693) beeline "source" command freezes if you have a comment in it?

2017-05-20 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-16693?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16018515#comment-16018515 ] Carter Shanklin commented on HIVE-16693: Looks good > beeline "source" command fr

[jira] [Updated] (HIVE-16693) beeline "source" command freezes if you have a comment in it?

2017-05-17 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-16693?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carter Shanklin updated HIVE-16693: --- Summary: beeline "source" command freezes if you have a comment in it? (was: beeline "souce"

[jira] [Commented] (HIVE-16693) beeline "souce" command freezes if you have a comment in it?

2017-05-17 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-16693?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16014049#comment-16014049 ] Carter Shanklin commented on HIVE-16693: [~Ferd] any chance you can weigh in on th

[jira] [Commented] (HIVE-13583) E061-14: Search Conditions

2017-05-12 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-13583?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16008130#comment-16008130 ] Carter Shanklin commented on HIVE-13583: [~leftylev] Yes is true is not true

[jira] [Updated] (HIVE-16614) Support "set local time zone" statement

2017-05-09 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-16614?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carter Shanklin updated HIVE-16614: --- Description: HIVE-14412 introduces a timezone-aware timestamp. SQL has a concept of default t

[jira] [Updated] (HIVE-16615) Support Time Zone Specifiers (i.e. "at time zone X")

2017-05-09 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-16615?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carter Shanklin updated HIVE-16615: --- Description: HIVE-14412 introduces a timezone-aware timestamp. SQL has a concept of "time zon

[jira] [Updated] (HIVE-16615) Support Time Zone Specifiers (i.e. "at time zone X")

2017-05-09 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-16615?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carter Shanklin updated HIVE-16615: --- Summary: Support Time Zone Specifiers (i.e. "at time zone X") (was: Support Time Zone Specifi

[jira] [Commented] (HIVE-14412) Add a timezone-aware timestamp

2017-05-08 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-14412?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16001958#comment-16001958 ] Carter Shanklin commented on HIVE-14412: Rui, tried the latest patch looks great.

[jira] [Commented] (HIVE-14412) Add a timezone-aware timestamp

2017-05-08 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-14412?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16001774#comment-16001774 ] Carter Shanklin commented on HIVE-14412: You can store the time zone or adjust the

[jira] [Commented] (HIVE-14412) Add a timezone-aware timestamp

2017-05-07 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-14412?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16000251#comment-16000251 ] Carter Shanklin commented on HIVE-14412: I tried the patch and had a few comments,

[jira] [Commented] (HIVE-16513) width_bucket issues

2017-05-07 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-16513?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15999879#comment-15999879 ] Carter Shanklin commented on HIVE-16513: [~leftylev] the original ticket should su

[jira] [Commented] (HIVE-16583) Select query fails with some exception error

2017-05-04 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-16583?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15997584#comment-15997584 ] Carter Shanklin commented on HIVE-16583: Can you post DDL and some sample data? >

[jira] [Commented] (HIVE-16574) Select count(*) throws ClassCastException in the presence of struct data type

2017-05-04 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-16574?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15997573#comment-15997573 ] Carter Shanklin commented on HIVE-16574: I am not able to reproduce this. Here is

[jira] [Commented] (HIVE-16575) Support for 'UNIQUE' and 'NOT NULL' constraints

2017-05-04 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-16575?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15996805#comment-15996805 ] Carter Shanklin commented on HIVE-16575: [~jcamachorodriguez] A note on the standa

[jira] [Commented] (HIVE-16513) width_bucket issues

2017-04-25 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-16513?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15983289#comment-15983289 ] Carter Shanklin commented on HIVE-16513: Confirmed the same here. As for the group

[jira] [Commented] (HIVE-16513) width_bucket issues

2017-04-23 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-16513?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15980618#comment-15980618 ] Carter Shanklin commented on HIVE-16513: Another update, the case expression thing

[jira] [Commented] (HIVE-15982) Support the width_bucket function

2017-04-23 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15982?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15980578#comment-15980578 ] Carter Shanklin commented on HIVE-15982: I ran a test suite I use against this and

[jira] [Commented] (HIVE-16513) width_bucket issues

2017-04-23 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-16513?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15980577#comment-15980577 ] Carter Shanklin commented on HIVE-16513: Further note, the error you get for the c

[jira] [Commented] (HIVE-16496) Enhance asterisk expression (as in "select *") with EXCLUDE clause

2017-04-21 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-16496?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15979553#comment-15979553 ] Carter Shanklin commented on HIVE-16496: I'll mention that the first use case, tha

[jira] [Comment Edited] (HIVE-16496) Enhance asterisk expression (as in "select *") with EXCLUDE clause

2017-04-21 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-16496?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15979553#comment-15979553 ] Carter Shanklin edited comment on HIVE-16496 at 4/21/17 11:17 PM: --

[jira] [Comment Edited] (HIVE-13582) E061-07 and E061-12: Quantified Comparison Predicates

2017-04-21 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-13582?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15978875#comment-15978875 ] Carter Shanklin edited comment on HIVE-13582 at 4/21/17 3:03 PM: ---

[jira] [Commented] (HIVE-13582) E061-07 and E061-12: Quantified Comparison Predicates

2017-04-21 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-13582?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15978875#comment-15978875 ] Carter Shanklin commented on HIVE-13582: Since this came up on HIVE-15229, a few m

[jira] [Commented] (HIVE-15229) 'like any' and 'like all' operators in hive

2017-04-21 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15229?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15978843#comment-15978843 ] Carter Shanklin commented on HIVE-15229: [~vgarg] the quantified comparison predic

[jira] [Commented] (HIVE-15982) Support the width_bucket function

2017-04-17 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15982?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15971687#comment-15971687 ] Carter Shanklin commented on HIVE-15982: [~stakiar] Sorry for the delayed respons

[jira] [Commented] (HIVE-15229) 'like any' and 'like all' operators in hive

2017-04-13 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15229?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15968570#comment-15968570 ] Carter Shanklin commented on HIVE-15229: [~simanchal] [~vgarg] [~pxiong] This app

[jira] [Commented] (HIVE-15982) Support the width_bucket function

2017-04-11 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15982?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15964466#comment-15964466 ] Carter Shanklin commented on HIVE-15982: [~stakiar] no problem at all, thanks for

[jira] [Commented] (HIVE-15269) Dynamic Min-Max/BloomFilter runtime-filtering for Tez

2017-03-28 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15269?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15946520#comment-15946520 ] Carter Shanklin commented on HIVE-15269: There are a few settings here that should

[jira] [Commented] (HIVE-11529) Loop optimization for SIMD in IfExprLong*Long*

2017-03-28 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-11529?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15946152#comment-15946152 ] Carter Shanklin commented on HIVE-11529: [~teddy.choi] did this ever make it in?

[jira] [Commented] (HIVE-14077) add implicit decimal arithmetic q test, fix issues if found

2017-03-27 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-14077?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15944259#comment-15944259 ] Carter Shanklin commented on HIVE-14077: Is the description on HIVE-13380 wrong? H

[jira] [Commented] (HIVE-14077) add implicit decimal arithmetic q test, fix issues if found

2017-03-27 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-14077?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15944238#comment-15944238 ] Carter Shanklin commented on HIVE-14077: [~sershe] [~ashutoshc] Great if this is

[jira] [Commented] (HIVE-14077) revert or fix HIVE-13380

2017-03-27 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-14077?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15943428#comment-15943428 ] Carter Shanklin commented on HIVE-14077: FWIW SQL standard states any precise nume

[jira] [Commented] (HIVE-16300) Allow to specify target table columns in static partition insert

2017-03-26 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-16300?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15942502#comment-15942502 ] Carter Shanklin commented on HIVE-16300: IMO Hive should implement standard "inser

[jira] [Updated] (HIVE-15978) Support regr_* functions

2017-03-20 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15978?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carter Shanklin updated HIVE-15978: --- Labels: (was: TODOC2.2) > Support regr_* functions > > >

[jira] [Updated] (HIVE-15979) Support character_length and octet_length

2017-03-19 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15979?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carter Shanklin updated HIVE-15979: --- Labels: (was: TODOC2.2) > Support character_length and octet_length > --

[jira] [Commented] (HIVE-15979) Support character_length and octet_length

2017-03-19 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15979?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15932149#comment-15932149 ] Carter Shanklin commented on HIVE-15979: Added these, removing label (if I can...)

[jira] [Commented] (HIVE-16138) Query on ORC table returns no results when specifying a DECIMAL(25) column in a the where clause.

2017-03-07 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-16138?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15899680#comment-15899680 ] Carter Shanklin commented on HIVE-16138: [~mmccline] any insights on this one? >

[jira] [Commented] (HIVE-15996) Implement multiargument GROUPING function

2017-02-21 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15996?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15876956#comment-15876956 ] Carter Shanklin commented on HIVE-15996: [~julianhyde] I don't think so, GROUP_ID

[jira] [Commented] (HIVE-15814) ODBC - LOAD DATA - NullPointerException

2017-02-05 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15814?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15853278#comment-15853278 ] Carter Shanklin commented on HIVE-15814: [~pvillard] are you able to provide a way

[jira] [Commented] (HIVE-15166) Provide beeline option to set the jline history max size

2017-02-03 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15166?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15851918#comment-15851918 ] Carter Shanklin commented on HIVE-15166: [~ashutoshc] Can someone keep this one mo

[jira] [Commented] (HIVE-15581) Unable to use advanced aggregation with multiple inserts clause

2017-01-15 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15581?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15823178#comment-15823178 ] Carter Shanklin commented on HIVE-15581: Have you tried it with Hive on Tez? Not s

[jira] [Commented] (HIVE-15297) Hive should not split semicolon within quoted string literals

2017-01-06 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15297?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15806544#comment-15806544 ] Carter Shanklin commented on HIVE-15297: [~pxiong] same problem {code} hive> crea

[jira] [Commented] (HIVE-15297) Hive should not split semicolon within quoted string literals

2017-01-06 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15297?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15806373#comment-15806373 ] Carter Shanklin commented on HIVE-15297: [~pxiong] since you're in this code wante

[jira] [Commented] (HIVE-15105) Hive shell runs out of memory on Tez

2016-11-04 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15105?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15637550#comment-15637550 ] Carter Shanklin commented on HIVE-15105: Can you see if "set hive.exec.mode.local.

[jira] [Commented] (HIVE-14579) Add support for date extract

2016-09-30 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-14579?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15537876#comment-15537876 ] Carter Shanklin commented on HIVE-14579: [~jcamachorodriguez] this is great, thank

[jira] [Commented] (HIVE-13557) Make interval keyword optional while specifying DAY in interval arithmetic

2016-09-06 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-13557?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15468812#comment-15468812 ] Carter Shanklin commented on HIVE-13557: Hive supports interval but only with the

[jira] [Commented] (HIVE-14581) Add chr udf

2016-09-03 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-14581?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15461361#comment-15461361 ] Carter Shanklin commented on HIVE-14581: chr was added in HIVE-13063 > Add chr ud

[jira] [Commented] (HIVE-14523) ACID performance improvement patches

2016-08-31 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-14523?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15453597#comment-15453597 ] Carter Shanklin commented on HIVE-14523: [~saketj] great work, thanks for your con

[jira] [Commented] (HIVE-14660) ArrayIndexOutOfBoundsException on delete

2016-08-28 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-14660?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15443795#comment-15443795 ] Carter Shanklin commented on HIVE-14660: [~ekoifman] ran across this at random, n

[jira] [Commented] (HIVE-13180) WindowingTableFunction fails with ClassCastException: org.apache.hadoop.io.DoubleWritable

2016-08-05 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-13180?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15410039#comment-15410039 ] Carter Shanklin commented on HIVE-13180: Rajesh, is this fixed by the combination

[jira] [Updated] (HIVE-14416) NPE trying to move results of a subselect into an RDBMS using HPL/SQL

2016-08-03 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-14416?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carter Shanklin updated HIVE-14416: --- Description: I was trying to use HPL/SQL to move some records from Hive to MySQL using this s

[jira] [Commented] (HIVE-11600) Hive Parser to Support multi col in clause (x,y..) in ((..),..., ())

2016-07-30 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-11600?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15400892#comment-15400892 ] Carter Shanklin commented on HIVE-11600: It would be good to get this documented w

[jira] [Updated] (HIVE-14053) Hive should report that primary keys can't be null.

2016-06-17 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-14053?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carter Shanklin updated HIVE-14053: --- Priority: Minor (was: Major) > Hive should report that primary keys can't be null. >

[jira] [Updated] (HIVE-13575) Support multi-subquery in all cases.

2016-04-21 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-13575?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carter Shanklin updated HIVE-13575: --- Issue Type: Sub-task (was: Bug) Parent: HIVE-13554 > Support multi-subquery in all ca

[jira] [Updated] (HIVE-13576) E061-13: Eliminate restrictions that remain on correlated subquery.

2016-04-21 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-13576?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carter Shanklin updated HIVE-13576: --- Issue Type: Sub-task (was: Bug) Parent: HIVE-13554 > E061-13: Eliminate restrictions

[jira] [Updated] (HIVE-13577) E061-09: Subqueries in comparison predicate

2016-04-21 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-13577?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carter Shanklin updated HIVE-13577: --- Issue Type: Sub-task (was: Bug) Parent: HIVE-13554 > E061-09: Subqueries in compariso

[jira] [Updated] (HIVE-13578) F471: Scalar subquery values

2016-04-21 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-13578?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carter Shanklin updated HIVE-13578: --- Issue Type: Sub-task (was: Bug) Parent: HIVE-13554 > F471: Scalar subquery values > -

[jira] [Updated] (HIVE-13579) F304: EXCEPT ALL

2016-04-21 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-13579?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carter Shanklin updated HIVE-13579: --- Issue Type: Sub-task (was: Bug) Parent: HIVE-13554 > F304: EXCEPT ALL > -

[jira] [Updated] (HIVE-13576) E061-13: Eliminate restrictions that remain on correlated subquery.

2016-04-21 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-13576?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carter Shanklin updated HIVE-13576: --- Summary: E061-13: Eliminate restrictions that remain on correlated subquery. (was: E061-13:�E

[jira] [Updated] (HIVE-13580) E071-03: EXCEPT DISTINCT

2016-04-21 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-13580?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carter Shanklin updated HIVE-13580: --- Issue Type: Sub-task (was: Bug) Parent: HIVE-13554 > E071-03: EXCEPT DISTINCT > -

[jira] [Updated] (HIVE-13581) F302-01 and F302-02: INTERSECT DISTINCT and INTERSECT ALL

2016-04-21 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-13581?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carter Shanklin updated HIVE-13581: --- Issue Type: Sub-task (was: Bug) Parent: HIVE-13554 > F302-01 and F302-02: INTERSECT D

[jira] [Updated] (HIVE-13582) E061-07 and E061-12: Quantified Comparison Predicates

2016-04-21 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-13582?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carter Shanklin updated HIVE-13582: --- Issue Type: Sub-task (was: Bug) Parent: HIVE-13554 > E061-07 and E061-12: Quantified

[jira] [Updated] (HIVE-13583) E061-14: Search Conditions

2016-04-21 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-13583?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carter Shanklin updated HIVE-13583: --- Issue Type: Sub-task (was: Bug) Parent: HIVE-13554 > E061-14: Search Conditions > ---

[jira] [Updated] (HIVE-13583) E061-14: Search Conditions

2016-04-21 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-13583?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carter Shanklin updated HIVE-13583: --- Issue Type: Sub-task (was: Bug) Parent: HIVE-13354 > E061-14: Search Conditions > ---

[jira] [Updated] (HIVE-13583) E061-14: Search Conditions

2016-04-21 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-13583?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carter Shanklin updated HIVE-13583: --- Issue Type: Bug (was: Sub-task) Parent: (was: HIVE-13354) > E061-14: Search Condi

[jira] [Commented] (HIVE-2873) Qualifying a column name in an ORDER BY clause generates 'Error in semantic analysis'

2016-04-21 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2873?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15251997#comment-15251997 ] Carter Shanklin commented on HIVE-2873: --- [~dzanter] Are you still seeing this? This d

[jira] [Commented] (HIVE-12835) BC dates not properly documented / handled

2016-03-19 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-12835?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15202242#comment-15202242 ] Carter Shanklin commented on HIVE-12835: Some other oddities: {code} hive> select

[jira] [Commented] (HIVE-12237) Use slf4j as logging facade

2016-02-09 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-12237?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15140253#comment-15140253 ] Carter Shanklin commented on HIVE-12237: The docs do need an update as I've found,

[jira] [Commented] (HIVE-12274) Increase width of columns used for general configuration in the metastore.

2016-01-14 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-12274?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15098471#comment-15098471 ] Carter Shanklin commented on HIVE-12274: [~teabot] can you post a sample DDL? What

[jira] [Updated] (HIVE-12682) Reducers in dynamic partitioning job spend a lot of time running hadoop.conf.Configuration.getOverlay

2015-12-15 Thread Carter Shanklin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-12682?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carter Shanklin updated HIVE-12682: --- Attachment: reducer.png > Reducers in dynamic partitioning job spend a lot of time running >

  1   2   >