[
https://issues.apache.org/jira/browse/HIVE-6552?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13922045#comment-13922045
]
Navis commented on HIVE-6552:
-----------------------------
Seemed fixed by HIVE-5945.
> Failed to generate new mapJoin operator by exception : Big Table Alias is null
> ------------------------------------------------------------------------------
>
> Key: HIVE-6552
> URL: https://issues.apache.org/jira/browse/HIVE-6552
> Project: Hive
> Issue Type: Bug
> Components: HiveServer2
> Affects Versions: 0.12.0
> Environment: Hive version:
> getBranch() : bigwheel-m16-0.12.0
> getBuildVersion(): 0.12.0.2.0.6.1-101 from
> 8b1b43ece7c96d3cf38fda84414b23e3b707026e by jenkins source checksum
> 1c1e5eb051cefce14af4d621654dc423
> getDate() : Wed Jan 8 22:20:16 PST 2014
> getRevision() : 8b1b43ece7c96d3cf38fda84414b23e3b707026e
> getSrcChecksum() : 1c1e5eb051cefce14af4d621654dc423
> getUrl() :
> git://c64-s17/grid/0/workspace/BIGTOP-HDP_RPM_REPO-bigwheel-M16/label/centos6-builds/bigtop-0.5/build/hive/rpm/BUILD/hive-0.12.0.2.0.6.1
> getUser() : jenkins
> getVersion() : 0.12.0.2.0.6.1-101
> OS: Red Hat Enterprise Linux Server release 6.4 x86_64
> JVM: java version "1.6.0_31"
> Java(TM) SE Runtime Environment (build 1.6.0_31-b04)
> Java HotSpot(TM) 64-Bit Server VM (build 20.6-b01, mixed mode)
> Hadoop:
> Hadoop 2.2.0.2.0.6.0-101
> Subversion [email protected]:hortonworks/hadoop.git -r
> b07b2906c36defd389c8b5bd22bebc1bead8115b
> Compiled by jenkins on 2014-01-09T05:18Z
> Compiled with protoc 2.5.0
> From source with checksum 704f1e463ebc4fb89353011407e965
> Reporter: Martin Kudlej
>
> I've tried BigTop test for UNIQUEJOIN:
> CREATE TABLE T1(key STRING, val STRING) STORED AS TEXTFILE;
> CREATE TABLE T2(key STRING, val STRING) STORED AS TEXTFILE;
> CREATE TABLE T3(key STRING, val STRING) STORED AS
> TEXTFILE;
> LOAD DATA LOCAL INPATH 'seed_data_files/T1.txt' INTO TABLE T1;
> LOAD DATA LOCAL INPATH 'seed_data_files/T2.txt'
> INTO TABLE T2;
> LOAD DATA LOCAL INPATH 'seed_data_files/T3.txt' INTO TABLE T3;
>
> FROM UNIQUEJOIN PRESERVE T1 a (a.key), PRESERVE T2 b (b.key), PRESERVE T3 c
> (c.key)
> SELECT a.key, b.key, c.key;
> where T1.txt is:
> 111
> 212
> 313
> 717
> 818
> 828
> and T2.txt is:
> 222
> 313
> 414
> 515
> 818
> 818
> and T3.txt is:
> 212
> 414
> 616
> 717
> if hive.auto.convert.join=false it works and result is:
> 1 NULL NULL
> 2 2 2
> 3 3 NULL
> NULL 4 4
> NULL 5 NULL
> NULL NULL 6
> 7 NULL 7
> 8 8 NULL
> 8 8 NULL
> 8 8 NULL
> 8 8 NULL
> but hive.auto.convert.join=true it failed:
> > FROM UNIQUEJOIN PRESERVE T1 a (a.key), PRESERVE T2 b (b.key), PRESERVE T3 c
> > (c.key) SELECT a.key, b.key, c.key
> org.apache.hadoop.hive.ql.parse.SemanticException: Big Table Alias is null
> at
> org.apache.hadoop.hive.ql.optimizer.MapJoinProcessor.genMapJoinLocalWork(MapJoinProcessor.java:225)
> at
> org.apache.hadoop.hive.ql.optimizer.MapJoinProcessor.genLocalWorkForMapJoin(MapJoinProcessor.java:256)
> at
> org.apache.hadoop.hive.ql.optimizer.MapJoinProcessor.genMapJoinOpAndLocalWork(MapJoinProcessor.java:248)
> at
> org.apache.hadoop.hive.ql.optimizer.physical.CommonJoinTaskDispatcher.convertTaskToMapJoinTask(CommonJoinTaskDispatcher.java:191)
> at
> org.apache.hadoop.hive.ql.optimizer.physical.CommonJoinTaskDispatcher.processCurrentTask(CommonJoinTaskDispatcher.java:480)
> at
> org.apache.hadoop.hive.ql.optimizer.physical.AbstractJoinTaskDispatcher.dispatch(AbstractJoinTaskDispatcher.java:182)
> at
> org.apache.hadoop.hive.ql.lib.TaskGraphWalker.dispatch(TaskGraphWalker.java:111)
> at
> org.apache.hadoop.hive.ql.lib.TaskGraphWalker.walk(TaskGraphWalker.java:194)
> at
> org.apache.hadoop.hive.ql.lib.TaskGraphWalker.startWalking(TaskGraphWalker.java:139)
> at
> org.apache.hadoop.hive.ql.optimizer.physical.CommonJoinResolver.resolve(CommonJoinResolver.java:79)
> at
> org.apache.hadoop.hive.ql.optimizer.physical.PhysicalOptimizer.optimize(PhysicalOptimizer.java:90)
> at
> org.apache.hadoop.hive.ql.parse.MapReduceCompiler.compile(MapReduceCompiler.java:300)
> at
> org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:8410)
> at
> org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:284)
> at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:441)
> at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:342)
> at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1000)
> at org.apache.hadoop.hive.ql.Driver.run(Driver.java:911)
> at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:259)
> at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:216)
> at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:413)
> at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:348)
> at org.apache.hadoop.hive.cli.CliDriver.processReader(CliDriver.java:446)
> at org.apache.hadoop.hive.cli.CliDriver.processFile(CliDriver.java:456)
> at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:737)
> at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:675)
> at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:614)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at org.apache.hadoop.util.RunJar.main(RunJar.java:212)
> org.apache.hadoop.hive.ql.parse.SemanticException: Failed to generate new
> mapJoin operator by exception : Big Table Alias is null
--
This message was sent by Atlassian JIRA
(v6.2#6252)
