Mailing-List: contact dev-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hive.apache.org
Date: Thu, 7 Jun 2012 05:08:23 +0000 (UTC)
From: "Miki Tanaka (JIRA)" <jira@apache.org>
To: hive-dev@hadoop.apache.org
Message-ID: <416441803.46450.1339045703416.JavaMail.jiratomcat@issues-vm>
In-Reply-To: <1533554834.43367.1338982823170.JavaMail.jiratomcat@issues-vm>
Subject: [jira] [Resolved] (HIVE-3093) TABLESAMPLE doesnt work with LEFT
 OUTER JOIN
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


     [ https://issues.apache.org/jira/browse/HIVE-3093?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Miki Tanaka resolved HIVE-3093.
-------------------------------

    Resolution: Fixed
    
> TABLESAMPLE doesnt work with LEFT OUTER JOIN
> --------------------------------------------
>
>                 Key: HIVE-3093
>                 URL: https://issues.apache.org/jira/browse/HIVE-3093
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Miki Tanaka
>
> SELECT * FROM (table1) a LEFT OUTER JOIN (table2) b ON (a.j1 = b.j2) TABLESAMPLE (BUCKET 1 OUT OF 512 ON a.col1) GROUP BY a.col1, b.col1 
> Got the error below.
> Error in QueryHive::query_via_thrift after 1 retries. error=Query returned non-zero code: 11, cause: FAILED: Parse Error: line 1:418 mismatched input 'tablesample' expecting EOF near ')'
> Also tried the below for enfancing sub query 'x'.
> SELECT * FROM (SELECT * FROM (table1) a LEFT OUTER JOIN (table2) b ON (a.j1 = b.j2) GROUP BY a.col1, b.col1) x TABLESAMPLE (BUCKET 1 OUT OF 512 ON a.col1) 
> Faild as below...
> Error in QueryHive::query_via_thrift after 1 retries. error=Query returned non-zero code: 11, cause: FAILED: Parse Error: line 1:100 cannot recognize input near '(' 'select' in subquery source
> Anyone help for it?
> I dont know how to open any attachment here, would be appriciated it if you fill in your comments directly here...

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira