[
https://issues.apache.org/jira/browse/PHOENIX-4919?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16689195#comment-16689195
]
Alexander commented on PHOENIX-4919:
------------------------------------
[~Jaanai], I just used commands from official documentation.
first of all, i created index async
{code:java}
create local index if not exists col1__local_idx on mark.kiz__current_state
("col1") include ("col2", "col3", "col4", .. ) async
{code}
next, I launched MR job
{code:java}
hadoop jar /usr/hdp/current/phoenix-client/phoenix-client.jar
org.apache.phoenix.mapreduce.index.IndexTool --schema 'MARK' --data-table
'KIZ__CURRENT_STATE' --index-table 'COL1__LOCAL_IDX' --output-path
ASYNC_col1__local_idx
{code}
But I was getting an error "TableNotFoundException" every time
I have got about 40 cols and 6 millions rows in the table.
> Asynchronous index creation fails with TableNotFoundException
> -------------------------------------------------------------
>
> Key: PHOENIX-4919
> URL: https://issues.apache.org/jira/browse/PHOENIX-4919
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 5.0.0
> Reporter: Alexander
> Priority: Major
>
> Index creation raises exception but table exists.
> {code:java}
> // Error: java.lang.RuntimeException:
> org.apache.phoenix.schema.TableNotFoundException: ERROR 1012 (42M03): Table
> undefined. tableName=MARK.KIZ__CURRENT_STATE
> at
> org.apache.phoenix.mapreduce.index.PhoenixIndexImportMapper.map(PhoenixIndexImportMapper.java:124)
> at
> org.apache.phoenix.mapreduce.index.PhoenixIndexImportMapper.map(PhoenixIndexImportMapper.java:50)
> at org.apache.hadoop.mapreduce.Mapper.run(Mapper.java:146)
> at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:799)
> at org.apache.hadoop.mapred.MapTask.run(MapTask.java:347)
> at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:174)
> at java.security.AccessController.doPrivileged(Native Method)
> at javax.security.auth.Subject.doAs(Subject.java:422)
> at
> org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1688)
> at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:168)
> Caused by: org.apache.phoenix.schema.TableNotFoundException: ERROR 1012
> (42M03): Table undefined. tableName=MARK.KIZ__CURRENT_STATE
> at
> org.apache.phoenix.query.ConnectionQueryServicesImpl.getTableRegionLocation(ConnectionQueryServicesImpl.java:4544)
> at
> org.apache.phoenix.query.DelegateConnectionQueryServices.getTableRegionLocation(DelegateConnectionQueryServices.java:312)
> at
> org.apache.phoenix.compile.UpsertCompiler.setValues(UpsertCompiler.java:163)
> at
> org.apache.phoenix.compile.UpsertCompiler.access$500(UpsertCompiler.java:118)
> at
> org.apache.phoenix.compile.UpsertCompiler$UpsertValuesMutationPlan.execute(UpsertCompiler.java:1202)
> at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:408)
> at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:391)
> at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
> at
> org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:390)
> at
> org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:378)
> at
> org.apache.phoenix.jdbc.PhoenixPreparedStatement.execute(PhoenixPreparedStatement.java:173)
> at
> org.apache.phoenix.jdbc.PhoenixPreparedStatement.execute(PhoenixPreparedStatement.java:183)
> at
> org.apache.phoenix.mapreduce.index.PhoenixIndexImportMapper.map(PhoenixIndexImportMapper.java:103)
> заполнитель кода
> {code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
