phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Marcin Januszkiewicz (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (PHOENIX-4308) Cannot use IndexTool to populate index table when using a functional index on non-default column family.
Date Fri, 20 Oct 2017 12:47:00 GMT

     [ 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)

Mime
View raw message