You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Vu Hoang (JIRA)" <ji...@apache.org> on 2010/01/15 04:46:54 UTC

[jira] Created: (HIVE-1052) Hive jdbc client - throws exception when query was too long

Hive jdbc client - throws exception when query was too long
-----------------------------------------------------------

                 Key: HIVE-1052
                 URL: https://issues.apache.org/jira/browse/HIVE-1052
             Project: Hadoop Hive
          Issue Type: Bug
          Components: Query Processor
    Affects Versions: 0.4.0
            Reporter: Vu Hoang
             Fix For: 0.4.2


I tried this query below
{noformat}
select columns from table where columnS='AAA' or columnS='BBB' or columnS='CCC' or ... etc
{noformat}
it took a long time and throw exception after that
{noformat}
FAILED: Parse Error: line 1:21 mismatched input 'from' expecting EOF
{noformat}
:(

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (HIVE-1052) Hive jdbc client - throws exception when query was too long

Posted by "Carl Steinbach (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-1052?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Carl Steinbach updated HIVE-1052:
---------------------------------

    Fix Version/s:     (was: 0.4.2)
      Component/s: Drivers

> Hive jdbc client - throws exception when query was too long
> -----------------------------------------------------------
>
>                 Key: HIVE-1052
>                 URL: https://issues.apache.org/jira/browse/HIVE-1052
>             Project: Hadoop Hive
>          Issue Type: Bug
>          Components: Drivers, Query Processor
>    Affects Versions: 0.4.0
>            Reporter: Vu Hoang
>
> I tried this query below
> {noformat}
> select columns from table where columnS='AAA' or columnS='BBB' or columnS='CCC' or ... etc
> {noformat}
> it took a long time and throw exception after that
> ... for hive jdbc
> {noformat}
> FAILED: Unknown exception: org.apache.hadoop.security.AccessControlException: 
> org.apache.hadoop.security.AccessControlException: Permission denied: user=DrWho, access=WRITE, inode="hive-asadm":asadm:asadm:rwxr-xr-x
> {noformat}
> ... for hive shell bash
> {noformat}
> FAILED: Parse Error: line 1:21 mismatched input 'from' expecting EOF ()
> {noformat}
> :(

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (HIVE-1052) Hive jdbc client - throws exception when query was too long

Posted by "Vu Hoang (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-1052?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Vu Hoang updated HIVE-1052:
---------------------------

    Description: 
I tried this query below
{noformat}
select columns from table where columnS='AAA' or columnS='BBB' or columnS='CCC' or ... etc
{noformat}
it took a long time and throw exception after that
... for hive jdbc
{noformat}
FAILED: Unknown exception: org.apache.hadoop.security.AccessControlException: 
org.apache.hadoop.security.AccessControlException: Permission denied: user=DrWho, access=WRITE, inode="hive-asadm":asadm:asadm:rwxr-xr-x
{noformat}
... for hive shell bash
{noformat}
FAILED: Parse Error: line 1:21 mismatched input 'from' expecting EOF ()
{noformat}
:(



  was:
I tried this query below
{noformat}
select columns from table where columnS='AAA' or columnS='BBB' or columnS='CCC' or ... etc
{noformat}
it took a long time and throw exception after that
... for hive jdbc
{noformat}
FAILED: Unknown exception: org.apache.hadoop.security.AccessControlException: org.apache.hadoop.security.AccessControlException: Permission denied: user=DrWho, access=WRITE, inode="hive-asadm":asadm:asadm:rwxr-xr-x
{noformat}
... for hive shell bash
{noformat}
FAILED: Parse Error: line 1:21 mismatched input 'from' expecting EOF ()
{noformat}
:(




> Hive jdbc client - throws exception when query was too long
> -----------------------------------------------------------
>
>                 Key: HIVE-1052
>                 URL: https://issues.apache.org/jira/browse/HIVE-1052
>             Project: Hadoop Hive
>          Issue Type: Bug
>          Components: Query Processor
>    Affects Versions: 0.4.0
>            Reporter: Vu Hoang
>             Fix For: 0.4.2
>
>
> I tried this query below
> {noformat}
> select columns from table where columnS='AAA' or columnS='BBB' or columnS='CCC' or ... etc
> {noformat}
> it took a long time and throw exception after that
> ... for hive jdbc
> {noformat}
> FAILED: Unknown exception: org.apache.hadoop.security.AccessControlException: 
> org.apache.hadoop.security.AccessControlException: Permission denied: user=DrWho, access=WRITE, inode="hive-asadm":asadm:asadm:rwxr-xr-x
> {noformat}
> ... for hive shell bash
> {noformat}
> FAILED: Parse Error: line 1:21 mismatched input 'from' expecting EOF ()
> {noformat}
> :(

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (HIVE-1052) Hive jdbc client - throws exception when query was too long

Posted by "Vu Hoang (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-1052?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Vu Hoang updated HIVE-1052:
---------------------------

    Description: 
I tried this query below
{noformat}
select columns from table where columnS='AAA' or columnS='BBB' or columnS='CCC' or ... etc
{noformat}
it took a long time and throw exception after that
... for hive jdbc
{noformat}
FAILED: Unknown exception: org.apache.hadoop.security.AccessControlException: org.apache.hadoop.security.AccessControlException: Permission denied: user=DrWho, access=WRITE, inode="hive-asadm":asadm:asadm:rwxr-xr-x
{noformat}
... for hive shell bash
{noformat}
FAILED: Parse Error: line 1:21 mismatched input 'from' expecting EOF ()
{noformat}
:(



  was:
I tried this query below
{noformat}
select columns from table where columnS='AAA' or columnS='BBB' or columnS='CCC' or ... etc
{noformat}
it took a long time and throw exception after that
{noformat}
FAILED: Parse Error: line 1:21 mismatched input 'from' expecting EOF
{noformat}
:(


> Hive jdbc client - throws exception when query was too long
> -----------------------------------------------------------
>
>                 Key: HIVE-1052
>                 URL: https://issues.apache.org/jira/browse/HIVE-1052
>             Project: Hadoop Hive
>          Issue Type: Bug
>          Components: Query Processor
>    Affects Versions: 0.4.0
>            Reporter: Vu Hoang
>             Fix For: 0.4.2
>
>
> I tried this query below
> {noformat}
> select columns from table where columnS='AAA' or columnS='BBB' or columnS='CCC' or ... etc
> {noformat}
> it took a long time and throw exception after that
> ... for hive jdbc
> {noformat}
> FAILED: Unknown exception: org.apache.hadoop.security.AccessControlException: org.apache.hadoop.security.AccessControlException: Permission denied: user=DrWho, access=WRITE, inode="hive-asadm":asadm:asadm:rwxr-xr-x
> {noformat}
> ... for hive shell bash
> {noformat}
> FAILED: Parse Error: line 1:21 mismatched input 'from' expecting EOF ()
> {noformat}
> :(

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Commented: (HIVE-1052) Hive jdbc client - throws exception when query was too long

Posted by "Vu Hoang (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/HIVE-1052?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12800528#action_12800528 ] 

Vu Hoang commented on HIVE-1052:
--------------------------------

it just happens when i used too many OR clauses.

> Hive jdbc client - throws exception when query was too long
> -----------------------------------------------------------
>
>                 Key: HIVE-1052
>                 URL: https://issues.apache.org/jira/browse/HIVE-1052
>             Project: Hadoop Hive
>          Issue Type: Bug
>          Components: Query Processor
>    Affects Versions: 0.4.0
>            Reporter: Vu Hoang
>             Fix For: 0.4.2
>
>
> I tried this query below
> {noformat}
> select columns from table where columnS='AAA' or columnS='BBB' or columnS='CCC' or ... etc
> {noformat}
> it took a long time and throw exception after that
> {noformat}
> FAILED: Parse Error: line 1:21 mismatched input 'from' expecting EOF
> {noformat}
> :(

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.