[jira] [Commented] (HIVE-2409) Semicolons in strings/comments are parsed as query-ending.
[ https://issues.apache.org/jira/browse/HIVE-2409?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15842773#comment-15842773 ] Egmont Koblinger commented on HIVE-2409: I am currently out of the office for an extended period of time. Please send your message to Vajnorák István at [1]ivajno...@cloudera.com instead. [1] mailto:ivajno...@cloudera.com > Semicolons in strings/comments are parsed as query-ending. > -- > > Key: HIVE-2409 > URL: https://issues.apache.org/jira/browse/HIVE-2409 > Project: Hive > Issue Type: Bug > Components: Query Processor >Reporter: Adam Kramer > > This fails: > select '.*? (f_.*?)[ ;$]' from akramer_one_row ; > This succeeds: > select '.*? (f_.*?)[ \;$]' from akramer_one_row ; > ...there is no reasonable syntactic structure that wuold require the escaping > of a semicolon in a '-marked string. The query parser should NOT split on > semicolons that are in strings OR in comments. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-12160) Hbase table query execution fails in secured cluster when hive.exec.mode.local.auto is set to true
[
https://issues.apache.org/jira/browse/HIVE-12160?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15828297#comment-15828297
]
Egmont Koblinger commented on HIVE-12160:
-
I am currently out of the office for an extended period of time. Please send
your message to Vajnorák István at [1]ivajno...@cloudera.com instead.
[1] mailto:ivajno...@cloudera.com
> Hbase table query execution fails in secured cluster when
> hive.exec.mode.local.auto is set to true
> --
>
> Key: HIVE-12160
> URL: https://issues.apache.org/jira/browse/HIVE-12160
> Project: Hive
> Issue Type: Bug
> Components: Security
>Affects Versions: 1.1.0, 2.0.0
>Reporter: Aihua Xu
>Assignee: Aihua Xu
> Attachments: HIVE-12160.patch, HIVE-12160_trace.txt
>
>
> In a secured cluster with kerberos, a simple query like {{select count(*)
> from hbase_table;}} will fail with the following exception when
> hive.exec.mode.local.auto is set to true.
> {noformat}
> Error: Error while processing statement: FAILED: Execution Error, return code
> 134 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask (state=08S01,code=134)
> {noformat}
> There is another scenario which may be caused by the same reason.
> Set hive.auto.convert.join to true, the join query {{select * from hbase_t1
> join hbase_t2 on hbase_t1.id = hbase_t2.id;}} also fails with the following
> exception:
> {noformat}
> Error while processing statement: FAILED: Execution Error, return code 2 from
> org.apache.hadoop.hive.ql.exec.mr.MapredLocalTask (state=08S01,code=2)
> {noformat}
> The failure seems to be caused by: during the compiliation, the main process
> doesn't need to access HBase, so HBase token is acquired, thus whem the
> process passes the tokens to child process, HBase token is not included. In
> MapredLocalTask, since the separate child process doesn't have HBase token so
> it fails.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Commented] (HIVE-12676) [hive+impala] Alter table Rename to + Set location in a single step
[ https://issues.apache.org/jira/browse/HIVE-12676?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15057709#comment-15057709 ] Egmont Koblinger commented on HIVE-12676: - (Please let me know if I should file a separate jira for the same feature request in Impala.) > [hive+impala] Alter table Rename to + Set location in a single step > --- > > Key: HIVE-12676 > URL: https://issues.apache.org/jira/browse/HIVE-12676 > Project: Hive > Issue Type: Improvement > Components: hpl/sql >Reporter: Egmont Koblinger >Assignee: Dmitry Tolpeko >Priority: Minor > > Assume a nonstandard table location, let's say /foo/bar/table1. You might > want to rename from table1 to table2 and move the underlying data accordingly > to /foo/bar/table2. > The "alter table ... rename to ..." clause alters the table name, but in the > same step moves the data into the standard location > /user/hive/warehouse/table2. Then a subsequent "alter table ... set location > ..." can move it back to the desired location /foo/bar/table2. > This is problematic if there's any permission problem in the game, e.g. not > being able to write to /user/hive/warehouse. So it should be possible to move > the underlying data to its desired final place without intermittent places in > between. > A probably hard to discover workaround is to set the table to external, then > rename it, then set back to internal and then change its location. > It would be great to be able to do an "alter table ... rename to ... set > location ..." operation in a single step. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
