[
https://issues.apache.org/jira/browse/TRAFODION-1938?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
David Wayne Birdsall closed TRAFODION-1938.
-------------------------------------------
Resolution: Duplicate
Fix Version/s: 2.0-incubating
> Create index failure in schema using delimited identifier
> ---------------------------------------------------------
>
> Key: TRAFODION-1938
> URL: https://issues.apache.org/jira/browse/TRAFODION-1938
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-cmp
> Affects Versions: 2.0-incubating, 1.3-incubating
> Environment: Probably all; encountered on a development workstation
> Reporter: David Wayne Birdsall
> Assignee: David Wayne Birdsall
> Priority: Minor
> Fix For: 2.0-incubating
>
>
> The following sqlci session output demonstrates the problem. We create a
> schema using a delimited identifier for the schema name. Then we create a
> table in that schema, then put some data in it, then attempt to create an
> index on it. The CREATE INDEX fails in the code to load the data in the
> index. (Note: If there is no data in the table, CREATE INDEX succeeds.) This
> will be an issue in the future, for example, if we decided to add an index to
> an existing metadata table as part of a software upgrade.
> >>create schema "Wolfman_Jack";
> --- SQL operation complete.
> >>set schema "Wolfman_Jack";
> --- SQL operation complete.
> >>create table t1 (a int not null, b int not null, c int);
> --- SQL operation complete.
> >>drop table t1;
> --- SQL operation complete.
> >>fc create
> >>create table t1 (a int not null, b int not null, c int);
> .. i, primary key (a)
> >>create table t1 (a int not null, b int not null, c int, primary key (a));
> >>
> ..
> --- SQL operation complete.
> >>insert into t1 values (1,2,3),(4,5,6),(7,8,0);
> --- 3 row(s) inserted.
> >>create index it1 on t1(b);
> *** ERROR[8448] Unable to access Hbase interface. Call to
> ExpHbaseInterface::doBulkLoad returned error HBASE_DOBULK_LOAD_ERROR(-715).
> Cause:
> java.lang.IllegalArgumentException: Illegal character code:34, <"> at 10.
> User-space table qualifiers can only contain 'alphanumeric characters': i.e.
> [a-zA-Z_0-9-.]: TRAFODION."Wolfman_Jack".IT1
> org.apache.hadoop.hbase.TableName.isLegalTableQualifierName(TableName.java:195)
> org.apache.hadoop.hbase.TableName.isLegalTableQualifierName(TableName.java:149)
> org.apache.hadoop.hbase.TableName.<init>(TableName.java:308)
> org.apache.hadoop.hbase.TableName.createTableNameIfNecessary(TableName.java:344)
> org.apache.hadoop.hbase.TableName.valueOf(TableName.java:431)
> org.apache.hadoop.hbase.client.HTable.<init>(HTable.java:160)
> org.trafodion.sql.HBulkLoadClient.doBulkLoad(HBulkLoadClient.java:457)
> .
> *** ERROR[1081] Loading of index TRAFODION."Wolfman_Jack".IT1 failed
> unexpectedly.
> --- SQL operation failed with errors.
> >>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
