[
https://issues.apache.org/jira/browse/PHOENIX-4308?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Marcin Januszkiewicz updated PHOENIX-4308:
------------------------------------------
Description:
Table DDL:
{code:sql}
create table t(
rowkey VARCHAR PRIMARY KEY,
"cf"."vehicle.number" VARCHAR)
{code}
Index DDL:
{code:sql}
CREATE LOCAL INDEX test_00 ON t (UPPER("cf"."vehicle.number"));
{code}
Result:
{noformat}
ERROR index.IndexTool: An exception occurred while performing the indexing job:
SQLException: Unable to process column : UPPER('cf'.'vehicle.number'), expected
family-qualified name. at:
java.sql.SQLException: Unable to process column : UPPER('cf'.'vehicle.number'),
expected family-qualified name.
{noformat}
was:
Table DDL:
create table t(
rowkey VARCHAR PRIMARY KEY,
"cf"."vehicle.number" VARCHAR)
Index DDL:
CREATE LOCAL INDEX test_00 ON t (UPPER("cf"."vehicle.number"));
Result:
ERROR index.IndexTool: An exception occurred while performing the indexing job:
SQLException: Unable to process column : UPPER('cf'.'vehicle.number'), expected
family-qualified name. at:
java.sql.SQLException: Unable to process column : UPPER('cf'.'vehicle.number'),
expected family-qualified name.
> Cannot use IndexTool to populate index table when using a functional index on
> non-default column family.
> --------------------------------------------------------------------------------------------------------
>
> Key: PHOENIX-4308
> URL: https://issues.apache.org/jira/browse/PHOENIX-4308
> Project: Phoenix
> Issue Type: Bug
> Reporter: Marcin Januszkiewicz
>
> Table DDL:
> {code:sql}
> create table t(
> rowkey VARCHAR PRIMARY KEY,
> "cf"."vehicle.number" VARCHAR)
> {code}
> Index DDL:
> {code:sql}
> CREATE LOCAL INDEX test_00 ON t (UPPER("cf"."vehicle.number"));
> {code}
> Result:
> {noformat}
> ERROR index.IndexTool: An exception occurred while performing the indexing
> job: SQLException: Unable to process column : UPPER('cf'.'vehicle.number'),
> expected family-qualified name. at:
> java.sql.SQLException: Unable to process column :
> UPPER('cf'.'vehicle.number'), expected family-qualified name.
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
