FAQ
Thanks for the reply Greg Rahn. May i know will the future version of
Impala will include cross joins or cartesian products? Many thanks.

On Friday, June 7, 2013 1:51:49 PM UTC+8, Greg Rahn wrote:

Version 1 Impala only supports equality join thus cross joins or cartesian
products do not work.

On Thu, Jun 6, 2013 at 8:01 PM, <chie...@gmail.com <javascript:>> wrote:

Hi All,

Anyone know is there anyway to construct the query to support Cartesian
Product JOINs (*SELECTS * FROM stocks JOIN dividends;*) in impala?

Regards,
CYea

On Thursday, June 6, 2013 2:09:40 PM UTC+8, chie...@gmail.com wrote:

Hi All,

As I know hive support Cartesian Product JOINs (*SELECTS * FROM stocks
JOIN dividends;*). However, when i try it in Impala, i got the error
below:

*ERROR: Not ImplementedException: Join between 'stocks' and 'dividends'
requires at least one conjunctive equality predicate between the two tables.
*

May i know will the next release of Impala will support Cartesian
Product JOINs? Thanks.

Regards,
CYea

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupimpala-user @
categorieshadoop
postedJun 7, '13 at 5:59a
activeJun 7, '13 at 5:59a
posts1
users1
websitecloudera.com
irc#hadoop

1 user in discussion

Chiewyea: 1 post

People

Translate

site design / logo © 2021 Grokbase