You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "James Taylor (JIRA)" <ji...@apache.org> on 2014/03/26 23:54:14 UTC
[jira] [Commented] (PHOENIX-899) Using BINARY type in secondary
indexes fails when doing an UPSERT
[ https://issues.apache.org/jira/browse/PHOENIX-899?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13948595#comment-13948595 ]
James Taylor commented on PHOENIX-899:
--------------------------------------
We don't support indexing for a nullable fixed width for BINARY because we don't have a way to represent null and we don't have a way to convert BINARY to a variable length field (like we do with other fixed width types).
> Using BINARY type in secondary indexes fails when doing an UPSERT
> -----------------------------------------------------------------
>
> Key: PHOENIX-899
> URL: https://issues.apache.org/jira/browse/PHOENIX-899
> Project: Phoenix
> Issue Type: Bug
> Reporter: Samarth Jain
> Assignee: Samarth Jain
> Fix For: 3.0.0, 4.0.0
>
>
> {code}
> @Test
> public void testIndexCreation() throws Exception {
> Properties props = new Properties(TEST_PROPERTIES);
> Connection conn = DriverManager.getConnection(getUrl(), props);
> try {
> conn.createStatement().execute("CREATE TABLE IF NOT EXISTS t1 "
> + "( id BIGINT NOT NULL PRIMARY KEY" // INDEX_ID
> + ", t BINARY(16) NOT NULL" // INDEX_THING_ID
> + ", e BINARY(16) NOT NULL" // INDEX_EVENT_KEY
> + ", d DATE NOT NULL" // INDEX_TIMESTAMP
> + ", y BINARY(16) NULL" // INDEX_METATYPE_ID
> + ", v BINARY(16) NULL)"); // INDEX_VALUE
>
> conn.createStatement().execute("CREATE INDEX IF NOT EXISTS index1 ON t1 (t, e, d DESC)");
> conn.createStatement().execute("CREATE INDEX IF NOT EXISTS index2 ON t1 (t, d DESC, e)");
>
> String upsert = "UPSERT INTO t1 values (?, ?, ?, ?, ?, ?)";
> PreparedStatement stmt = conn.prepareStatement(upsert);
> stmt.setInt(1, 1);
> stmt.setBytes(2, "ABC".getBytes());
> stmt.setBytes(3, "BCD".getBytes());
> stmt.setDate(4, new Date(System.currentTimeMillis()));
> stmt.setBytes(5, "CDE".getBytes());
> stmt.setBytes(6, "BBNNB".getBytes());
> stmt.executeUpdate();
> conn.commit();
> } finally {
> conn.close();
> }
> }
> Exception:
> java.lang.IllegalArgumentException: Unsupported non nullable index type BINARY
> at org.apache.phoenix.util.IndexUtil.getIndexColumnDataType(IndexUtil.java:81)
> at org.apache.phoenix.index.IndexMaintainer.buildRowKey(IndexMaintainer.java:345)
> at org.apache.phoenix.index.IndexMaintainer.buildUpdateMutation(IndexMaintainer.java:391)
> at org.apache.phoenix.util.IndexUtil.generateIndexData(IndexUtil.java:185)
> at org.apache.phoenix.execute.MutationState$1.next(MutationState.java:203)
> at org.apache.phoenix.execute.MutationState$1.next(MutationState.java:186)
> at org.apache.phoenix.execute.MutationState.commit(MutationState.java:347)
> at org.apache.phoenix.jdbc.PhoenixConnection.commit(PhoenixConnection.java:351)
> at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:229)
> at org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:185)
> at org.apache.phoenix.jdbc.PhoenixPreparedStatement.execute(PhoenixPreparedStatement.java:146)
> at org.apache.phoenix.jdbc.PhoenixPreparedStatement.execute(PhoenixPreparedStatement.java:151)
> {code}
--
This message was sent by Atlassian JIRA
(v6.2#6252)