[ https://issues.apache.org/jira/browse/PHOENIX-2542?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
maghamravikiran updated PHOENIX-2542: ------------------------------------- Fix Version/s: 4.7.0 > CSV bulk loading with --schema option is broken > ----------------------------------------------- > > Key: PHOENIX-2542 > URL: https://issues.apache.org/jira/browse/PHOENIX-2542 > Project: Phoenix > Issue Type: Bug > Environment: Current master branch / HBase 1.1.2 > Reporter: YoungWoo Kim > Assignee: maghamravikiran > Fix For: 4.7.0 > > Attachments: PHOENIX-2542.patch > > > My bulk load command looks like this: > {code} > HADOOP_CLASSPATH=/usr/lib/hbase/hbase-protocol.jar:/etc/hbase/conf/ hadoop > jar /usr/lib/phoenix/phoenix-client.jar > org.apache.phoenix.mapreduce.CsvBulkLoadTool ${HADOOP_MR_RUNTIME_OPTS} > --schema MYSCHEMA --table MYTABLE --input /path/to/id=20151218000000/* -d > $'\001' > {code} > Got errors as following: > {noformat} > 15/12/21 11:47:40 INFO mapreduce.Job: Task Id : > attempt_1450018293185_0952_m_000004_2, Status : FAILED > Error: java.lang.RuntimeException: java.lang.RuntimeException: > org.apache.phoenix.schema.TableNotFoundException: ERROR 1012 (42M03): Table > undefined. tableName=MYTABLE > at > org.apache.phoenix.mapreduce.FormatToKeyValueMapper.map(FormatToKeyValueMapper.java:170) > at > org.apache.phoenix.mapreduce.FormatToKeyValueMapper.map(FormatToKeyValueMapper.java:61) > at org.apache.hadoop.mapreduce.Mapper.run(Mapper.java:145) > at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:787) > at org.apache.hadoop.mapred.MapTask.run(MapTask.java:341) > at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:163) > at java.security.AccessController.doPrivileged(Native Method) > at javax.security.auth.Subject.doAs(Subject.java:415) > at > org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1671) > at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:158) > Caused by: java.lang.RuntimeException: > org.apache.phoenix.schema.TableNotFoundException: ERROR 1012 (42M03): Table > undefined. tableName=MYTABLE > at com.google.common.base.Throwables.propagate(Throwables.java:156) > at > org.apache.phoenix.mapreduce.FormatToKeyValueMapper$MapperUpsertListener.errorOnRecord(FormatToKeyValueMapper.java:246) > at > org.apache.phoenix.util.csv.CsvUpsertExecutor.execute(CsvUpsertExecutor.java:92) > at > org.apache.phoenix.util.csv.CsvUpsertExecutor.execute(CsvUpsertExecutor.java:44) > at > org.apache.phoenix.util.UpsertExecutor.execute(UpsertExecutor.java:133) > at > org.apache.phoenix.mapreduce.FormatToKeyValueMapper.map(FormatToKeyValueMapper.java:147) > ... 9 more > Caused by: org.apache.phoenix.schema.TableNotFoundException: ERROR 1012 > (42M03): Table undefined. tableName=MYTABLE > at > org.apache.phoenix.compile.FromCompiler$BaseColumnResolver.createTableRef(FromCompiler.java:436) > at > org.apache.phoenix.compile.FromCompiler$SingleTableColumnResolver.<init>(FromCompiler.java:285) > at > org.apache.phoenix.compile.FromCompiler.getResolverForMutation(FromCompiler.java:249) > at > org.apache.phoenix.compile.UpsertCompiler.compile(UpsertCompiler.java:289) > at > org.apache.phoenix.jdbc.PhoenixStatement$ExecutableUpsertStatement.compilePlan(PhoenixStatement.java:578) > at > org.apache.phoenix.jdbc.PhoenixStatement$ExecutableUpsertStatement.compilePlan(PhoenixStatement.java:566) > at > org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:331) > at > org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:326) > at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53) > at > org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:324) > at > org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:245) > at > org.apache.phoenix.jdbc.PhoenixPreparedStatement.execute(PhoenixPreparedStatement.java:172) > at > org.apache.phoenix.jdbc.PhoenixPreparedStatement.execute(PhoenixPreparedStatement.java:177) > at > org.apache.phoenix.util.csv.CsvUpsertExecutor.execute(CsvUpsertExecutor.java:84) > ... 12 more > {noformat} > My table MYSCHEMA.MYTABLE exists but bulk load tool does not recognize my > schema name. -- This message was sent by Atlassian JIRA (v6.3.4#6332)