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

[ https://issues.apache.org/jira/browse/HIVE-21117?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16742670#comment-16742670 ] Carter Shanklin commented on HIVE-21117: Postgres uses extract(isoyear from date) for this. This

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

[ https://issues.apache.org/jira/browse/HIVE-16944?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16432349#comment-16432349 ] Carter Shanklin commented on HIVE-16944: [~bharos92] I'm not working with Hive these days so I

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

[ https://issues.apache.org/jira/browse/HIVE-17869?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16215532#comment-16215532 ] Carter Shanklin commented on HIVE-17869: Seems to be the same as HIVE-17038 which has a PR

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

[ 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

[ https://issues.apache.org/jira/browse/HIVE-17135?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16094887#comment-16094887 ] Carter Shanklin commented on HIVE-17135: One more problem: Connection Refused is also not reported

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

[ 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

[ 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

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

[ 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)

[ https://issues.apache.org/jira/browse/HIVE-17018?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16088721#comment-16088721 ] Carter Shanklin commented on HIVE-17018: My inputs: That particular variable can't be renamed to

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

[ https://issues.apache.org/jira/browse/HIVE-10924?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16078708#comment-16078708 ] Carter Shanklin commented on HIVE-10924: [~Absolutesantaja] that's a good call out, can you file a

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

[ https://issues.apache.org/jira/browse/HIVE-17013?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=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

[ https://issues.apache.org/jira/browse/HIVE-17013?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=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

[ https://issues.apache.org/jira/browse/HIVE-17013?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16073900#comment-16073900 ] Carter Shanklin commented on HIVE-17013: [~ekoifman] I'm seeing this as well. Oddly even the

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

[ https://issues.apache.org/jira/browse/HIVE-16496?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16068556#comment-16068556 ] Carter Shanklin commented on HIVE-16496: Ran across this today:

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

[ https://issues.apache.org/jira/browse/HIVE-6348?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16067709#comment-16067709 ] Carter Shanklin commented on HIVE-6348: --- It's trivia at this point but ORDER BY in subquery is

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

[ https://issues.apache.org/jira/browse/HIVE-16434?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=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

[ https://issues.apache.org/jira/browse/HIVE-16434?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16062447#comment-16062447 ] Carter Shanklin commented on HIVE-16434: SQL:2016 adds parsing templates and a format keyword as:

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

[ https://issues.apache.org/jira/browse/HIVE-16944?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16059560#comment-16059560 ] Carter Shanklin commented on HIVE-16944: Also [~vihangk1] if you're interested in setting up

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

[ https://issues.apache.org/jira/browse/HIVE-16648?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16059504#comment-16059504 ] Carter Shanklin commented on HIVE-16648: To clarify I wasn't looking for a workaround but this

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

[ https://issues.apache.org/jira/browse/HIVE-16927?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16058239#comment-16058239 ] Carter Shanklin commented on HIVE-16927: [~sershe] [~prasanth_j] probably makes sense for one of

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

[ https://issues.apache.org/jira/browse/HIVE-16829?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16039160#comment-16039160 ] Carter Shanklin commented on HIVE-16829: This would be great to see (I see the ticket status is in

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

[ https://issues.apache.org/jira/browse/HIVE-6348?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16037458#comment-16037458 ] Carter Shanklin commented on HIVE-6348: --- I don't think banning is a good idea, there's just no way to

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

[ https://issues.apache.org/jira/browse/HIVE-16789?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16034806#comment-16034806 ] Carter Shanklin commented on HIVE-16789: There's also a 2.1.1 release which may solve the issue.

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

[ https://issues.apache.org/jira/browse/HIVE-16789?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16033094#comment-16033094 ] Carter Shanklin commented on HIVE-16789: This doesn't reproduce on HDP 2.5.3 (version =

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

[ https://issues.apache.org/jira/browse/HIVE-16789?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16031135#comment-16031135 ] Carter Shanklin commented on HIVE-16789: Does the error occur when using Tez instead of MapReduce

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

[ https://issues.apache.org/jira/browse/HIVE-16789?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16031135#comment-16031135 ] Carter Shanklin edited comment on HIVE-16789 at 5/31/17 1:18 PM: - Does the

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

[ 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:

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

[ https://issues.apache.org/jira/browse/HIVE-16763?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16025790#comment-16025790 ] Carter Shanklin commented on HIVE-16763: If we're considering adding double-quoted identifiers I

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

[ 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

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

[ https://issues.apache.org/jira/browse/HIVE-16695?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16020615#comment-16020615 ] Carter Shanklin commented on HIVE-16695: I'm unable to repro the issue now after the other patch

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

[ https://issues.apache.org/jira/browse/HIVE-16693?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16018515#comment-16018515 ] Carter Shanklin commented on HIVE-16693: Looks good > beeline "source" command freezes if you

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

[ 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?

[ https://issues.apache.org/jira/browse/HIVE-16693?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16014049#comment-16014049 ] Carter Shanklin commented on HIVE-16693: [~Ferd] any chance you can weigh in on this? (believe the

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

[ https://issues.apache.org/jira/browse/HIVE-13583?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16008130#comment-16008130 ] Carter Shanklin commented on HIVE-13583: [~leftylev] Yes is true is not true is false is not

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

[ 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

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

[ 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

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

[ 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

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

[ https://issues.apache.org/jira/browse/HIVE-14412?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16001958#comment-16001958 ] Carter Shanklin commented on HIVE-14412: Rui, tried the latest patch looks great. > Add a

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

[ https://issues.apache.org/jira/browse/HIVE-14412?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16001774#comment-16001774 ] Carter Shanklin commented on HIVE-14412: You can store the time zone or adjust the values based on

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

[ https://issues.apache.org/jira/browse/HIVE-14412?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16000251#comment-16000251 ] Carter Shanklin commented on HIVE-14412: I tried the patch and had a few comments, 1 relates to

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

[ https://issues.apache.org/jira/browse/HIVE-16513?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15999879#comment-15999879 ] Carter Shanklin commented on HIVE-16513: [~leftylev] the original ticket should suffice >

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

[ https://issues.apache.org/jira/browse/HIVE-16583?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15997584#comment-15997584 ] Carter Shanklin commented on HIVE-16583: Can you post DDL and some sample data? > Select query

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

[ https://issues.apache.org/jira/browse/HIVE-16574?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15997573#comment-15997573 ] Carter Shanklin commented on HIVE-16574: I am not able to reproduce this. Here is the script I

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

[ https://issues.apache.org/jira/browse/HIVE-16575?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15996805#comment-15996805 ] Carter Shanklin commented on HIVE-16575: [~jcamachorodriguez] A note on the standard: SQL:2011

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

[ https://issues.apache.org/jira/browse/HIVE-16513?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15983289#comment-15983289 ] Carter Shanklin commented on HIVE-16513: Confirmed the same here. As for the grouping thing I

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

[ https://issues.apache.org/jira/browse/HIVE-16513?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15980618#comment-15980618 ] Carter Shanklin commented on HIVE-16513: Another update, the case expression thing turns out to be

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

[ https://issues.apache.org/jira/browse/HIVE-15982?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15980578#comment-15980578 ] Carter Shanklin commented on HIVE-15982: I ran a test suite I use against this and noted a few

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

[ https://issues.apache.org/jira/browse/HIVE-16513?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15980577#comment-15980577 ] Carter Shanklin commented on HIVE-16513: Further note, the error you get for the case items is:

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

[ https://issues.apache.org/jira/browse/HIVE-16496?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15979553#comment-15979553 ] Carter Shanklin commented on HIVE-16496: I'll mention that the first use case, that of excluding

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

[ https://issues.apache.org/jira/browse/HIVE-16496?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15979553#comment-15979553 ] Carter Shanklin edited comment on HIVE-16496 at 4/21/17 11:17 PM: -- I'll

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

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

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

[ https://issues.apache.org/jira/browse/HIVE-13582?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15978875#comment-15978875 ] Carter Shanklin commented on HIVE-13582: Since this came up on HIVE-15229, a few more notes on

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

[ https://issues.apache.org/jira/browse/HIVE-15982?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15971687#comment-15971687 ] Carter Shanklin commented on HIVE-15982: [~stakiar] Sorry for the delayed response, I checked the

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

[ https://issues.apache.org/jira/browse/HIVE-15229?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15968570#comment-15968570 ] Carter Shanklin commented on HIVE-15229: [~simanchal] [~vgarg] [~pxiong] This appears to be a

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

[ https://issues.apache.org/jira/browse/HIVE-15982?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15964466#comment-15964466 ] Carter Shanklin commented on HIVE-15982: [~stakiar] no problem at all, thanks for looking into

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

[ https://issues.apache.org/jira/browse/HIVE-15269?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15946520#comment-15946520 ] Carter Shanklin commented on HIVE-15269: There are a few settings here that should be documented

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

[ https://issues.apache.org/jira/browse/HIVE-11529?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15946152#comment-15946152 ] Carter Shanklin commented on HIVE-11529: [~teddy.choi] did this ever make it in? > Loop

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

[ https://issues.apache.org/jira/browse/HIVE-14077?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15944259#comment-15944259 ] Carter Shanklin commented on HIVE-14077: Is the description on HIVE-13380 wrong? HIVE-13380 says

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

[ https://issues.apache.org/jira/browse/HIVE-14077?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15944238#comment-15944238 ] Carter Shanklin commented on HIVE-14077: [~sershe] [~ashutoshc] Great if this is not an issue

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

[ https://issues.apache.org/jira/browse/HIVE-14077?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15943428#comment-15943428 ] Carter Shanklin commented on HIVE-14077: FWIW SQL standard states any precise numeric type has

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

[ https://issues.apache.org/jira/browse/HIVE-16300?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15942502#comment-15942502 ] Carter Shanklin commented on HIVE-16300: IMO Hive should implement standard "insert column list"

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

[ 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

[ 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

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

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

[ https://issues.apache.org/jira/browse/HIVE-16138?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15899680#comment-15899680 ] Carter Shanklin commented on HIVE-16138: [~mmccline] any insights on this one? > Query on ORC

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

[ https://issues.apache.org/jira/browse/HIVE-15996?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15876956#comment-15876956 ] Carter Shanklin commented on HIVE-15996: [~julianhyde] I don't think so, GROUP_ID seems to depend

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

[ https://issues.apache.org/jira/browse/HIVE-15814?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15853278#comment-15853278 ] Carter Shanklin commented on HIVE-15814: [~pvillard] are you able to provide a way to reproduce

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

[ https://issues.apache.org/jira/browse/HIVE-15166?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15851918#comment-15851918 ] Carter Shanklin commented on HIVE-15166: [~ashutoshc] Can someone keep this one moving? We've got

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

[ https://issues.apache.org/jira/browse/HIVE-15581?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15823178#comment-15823178 ] Carter Shanklin commented on HIVE-15581: Have you tried it with Hive on Tez? Not saying it will

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

[ https://issues.apache.org/jira/browse/HIVE-15297?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15806544#comment-15806544 ] Carter Shanklin commented on HIVE-15297: [~pxiong] same problem {code} hive> create table test

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

[ https://issues.apache.org/jira/browse/HIVE-15297?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15806373#comment-15806373 ] Carter Shanklin commented on HIVE-15297: [~pxiong] since you're in this code wanted to flag this:

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

[ https://issues.apache.org/jira/browse/HIVE-15105?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15637550#comment-15637550 ] Carter Shanklin commented on HIVE-15105: Can you see if "set hive.exec.mode.local.auto=false;"

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

[ https://issues.apache.org/jira/browse/HIVE-14579?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15537876#comment-15537876 ] Carter Shanklin commented on HIVE-14579: [~jcamachorodriguez] this is great, thanks for that. One

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

[ https://issues.apache.org/jira/browse/HIVE-13557?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15468812#comment-15468812 ] Carter Shanklin commented on HIVE-13557: Hive supports interval but only with the singular forms,

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

[ https://issues.apache.org/jira/browse/HIVE-14581?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15461361#comment-15461361 ] Carter Shanklin commented on HIVE-14581: chr was added in HIVE-13063 > Add chr udf > ---

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

[ https://issues.apache.org/jira/browse/HIVE-14523?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15453597#comment-15453597 ] Carter Shanklin commented on HIVE-14523: [~saketj] great work, thanks for your contribution in

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

[ https://issues.apache.org/jira/browse/HIVE-14660?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15443795#comment-15443795 ] Carter Shanklin commented on HIVE-14660: [~ekoifman] ran across this at random, not sure if you

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

[ 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

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

[ https://issues.apache.org/jira/browse/HIVE-11600?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15400892#comment-15400892 ] Carter Shanklin commented on HIVE-11600: It would be good to get this documented without waiting

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

[ 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.

[ 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

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

[ 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

[ 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

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

[ 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

[ 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.

[ 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:

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

[ 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

[ 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

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

[ 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

[ 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

[ 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

[ 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

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

[ https://issues.apache.org/jira/browse/HIVE-2873?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15251997#comment-15251997 ] Carter Shanklin commented on HIVE-2873: --- [~dzanter] Are you still seeing this? This does not

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

[ https://issues.apache.org/jira/browse/HIVE-12835?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15202242#comment-15202242 ] Carter Shanklin commented on HIVE-12835: Some other oddities: {code} hive> select cast

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

[ https://issues.apache.org/jira/browse/HIVE-12237?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15140253#comment-15140253 ] Carter Shanklin commented on HIVE-12237: The docs do need an update as I've found, when I follow

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

[ https://issues.apache.org/jira/browse/HIVE-12274?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15098471#comment-15098471 ] Carter Shanklin commented on HIVE-12274: [~teabot] can you post a sample DDL? What serde are you

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

[ 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 >

[jira] [Commented] (HIVE-9028) Enhance the hive parser to accept tuples in where in clause filter

[ https://issues.apache.org/jira/browse/HIVE-9028?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15009897#comment-15009897 ] Carter Shanklin commented on HIVE-9028: --- Same as HIVE-11600 ? > Enhance the hive parser to accept

[jira] [Commented] (HIVE-9780) Add another level of explain for RDBMS audience

[ https://issues.apache.org/jira/browse/HIVE-9780?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15007080#comment-15007080 ] Carter Shanklin commented on HIVE-9780: --- This is so much better than the old style explain plans we

[jira] [Commented] (HIVE-11422) Join a ACID table with non-ACID table fail with MR

[ https://issues.apache.org/jira/browse/HIVE-11422?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14998816#comment-14998816 ] Carter Shanklin commented on HIVE-11422: [~daijy] is this a duplicate of HIVE-11438 ? > Join a

  1   2   >