[
https://issues.apache.org/jira/browse/PHOENIX-5834?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Istvan Toth resolved PHOENIX-5834.
----------------------------------
Resolution: Duplicate
> IndexTool cannot support tablename lowercase
> ---------------------------------------------
>
> Key: PHOENIX-5834
> URL: https://issues.apache.org/jira/browse/PHOENIX-5834
> Project: Phoenix
> Issue Type: Bug
> Components: core
> Affects Versions: 5.0.0
> Reporter: shining
> Priority: Major
>
> 1. Create table in hbase
> >> create 'ns:phoenix01','info'
> >> put 'ns:phoenix1','row001','info:id','1111'
> >> put 'ns:phoenix1','row001','info:name','manager'
> 2. Create table and async index in phoenix
> >> create schema "ns"
> >> create table "ns"."phoenix01"(ROW varchar primary key, "info"."id"
> varchar, "info"."name" varchar)column_encoded_bytes=0;
> >> create index "phoenix01_index" on "ns"."phoenix01"("info"."name") ASYNC;
> 3. Use IndexTool build index
> hbase org.apache.phoenix.mapreduce.index.IndexTool -s "ns" -dt "phoenix01"
> -it "phoenix01_index" -op /indextest
> Then i get nothing and return directly.
> I check the code and find the error position:
> {code:java}
> private boolean isValidIndexTable(final Connection connection, final String
> masterTable,
> final String indexTable) throws SQLException {
> final DatabaseMetaData dbMetaData = connection.getMetaData();
> final String schemaName =
> SchemaUtil.getSchemaNameFromFullName(masterTable);
> final String tableName =
> SchemaUtil.normalizeIdentifier(SchemaUtil.getTableNameFromFullName(masterTable));
> ResultSet rs = null;
> try {
> rs = dbMetaData.getIndexInfo(null, schemaName, tableName, false,
> false);
> while (rs.next()) {
> final String indexName = rs.getString(6);
> if (indexTable.equalsIgnoreCase(indexName)) {
> return true;
> }
> }
> } finally {
> if (rs != null) {
> rs.close();
> }
> }
> return false;
> }
> {code}
> I give the lowcase tablename,but indexTool change it uppercase,the
> validIndexTable get null.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
