[jira] [Updated] (PHOENIX-6428) Phoenix select subquery doesn't work on VARCHAR and CHAR types
[ https://issues.apache.org/jira/browse/PHOENIX-6428?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sandeep Pal updated PHOENIX-6428: - Description: Phoenix select subquery doesn't work on VARCHAR and CHAR types in two tables when column with type `CHAR(N)` as value lesser than N bytes. . Steps to reproduce: CREATE TABLE TEST.TABLE_WITH_VARCHAR (ID VARCHAR NOT NULL,CONSTRAINT PK PRIMARY KEY (ID)); CREATE TABLE TEST.TABLE_WITH_CHAR (ID CHAR(15) NOT NULL,CONSTRAINT PK PRIMARY KEY (ID)); UPSERT INTO TEST.TABLE_WITH_VARCHAR(ID) VALUES ('00'); UPSERT INTO TEST.TABLE_WITH_CHAR(ID) VALUES ('00'); select * from test.table_with_varchar where id not in (select id from test.table_with_char); {code:java} 0: jdbc:phoenix:localhost:56632> CREATE TABLE TEST.TABLE_WITH_VARCHAR (ID VARCHAR NOT NULL,CONSTRAINT PK PRIMARY KEY (ID)); No rows affected (2.354 seconds) 0: jdbc:phoenix:localhost:56632> CREATE TABLE TEST.TABLE_WITH_CHAR (ID CHAR(15) NOT NULL,CONSTRAINT PK PRIMARY KEY (ID)); No rows affected (2.254 seconds) 0: jdbc:phoenix:localhost:52919> UPSERT INTO TEST.TABLE_WITH_VARCHAR(ID) VALUES ('00'); 1 row affected (0.041 seconds) 0: jdbc:phoenix:localhost:52919> UPSERT INTO TEST.TABLE_WITH_CHAR(ID) VALUES ('00'); 1 row affected (0.004 seconds) 0: jdbc:phoenix:localhost:52919> select * from test.table_with_varchar where id not in (select id from test.table_with_char); ++ | ID | ++ | 00 | ++ 1 row selected (0.109 seconds) 0: jdbc:phoenix:localhost:52919> UPSERT INTO TEST.TABLE_WITH_CHAR(ID) VALUES ('ABC'); 1 row affected (0.005 seconds) 0: jdbc:phoenix:localhost:52919> UPSERT INTO TEST.TABLE_WITH_VARCHAR(ID) VALUES ('ABC'); 1 row affected (0.006 seconds) 0: jdbc:phoenix:localhost:52919> select * from test.table_with_varchar where id not in (select id from test.table_with_char); ++ | ID | ++ | 00 | | ABC| ++ 2 rows selected (0.026 seconds) 0: jdbc:phoenix:localhost:52919> select * from test.table_with_char; ++ | ID | ++ | 00 | | ABC| ++ 2 rows selected (0.013 seconds) 0: jdbc:phoenix:localhost:52919> select * from test.table_with_varchar; ++ | ID | ++ | 00 | | ABC| ++ 2 rows selected (0.011 seconds) 0: jdbc:phoenix:localhost:52919> select * from test.table_with_varchar where id in (select id from test.table_with_char); ++ | ID | ++ ++{code} This returns empty. was: Phoenix select subquery doesn't work on VARCHAR and CHAR types in two tables when column with type CHAR(n) as value lesser than n bytes. . Steps to reproduce: CREATE TABLE TEST.TABLE_WITH_VARCHAR (ID VARCHAR NOT NULL,CONSTRAINT PK PRIMARY KEY (ID)); CREATE TABLE TEST.TABLE_WITH_CHAR (ID CHAR(15) NOT NULL,CONSTRAINT PK PRIMARY KEY (ID)); UPSERT INTO TEST.TABLE_WITH_VARCHAR(ID) VALUES ('00'); UPSERT INTO TEST.TABLE_WITH_CHAR(ID) VALUES ('00'); select * from test.table_with_varchar where id not in (select id from test.table_with_char); {code:java} 0: jdbc:phoenix:localhost:56632> CREATE TABLE TEST.TABLE_WITH_VARCHAR (ID VARCHAR NOT NULL,CONSTRAINT PK PRIMARY KEY (ID)); No rows affected (2.354 seconds) 0: jdbc:phoenix:localhost:56632> CREATE TABLE TEST.TABLE_WITH_CHAR (ID CHAR(15) NOT NULL,CONSTRAINT PK PRIMARY KEY (ID)); No rows affected (2.254 seconds) 0: jdbc:phoenix:localhost:52919> UPSERT INTO TEST.TABLE_WITH_VARCHAR(ID) VALUES ('00'); 1 row affected (0.041 seconds) 0: jdbc:phoenix:localhost:52919> UPSERT INTO TEST.TABLE_WITH_CHAR(ID) VALUES ('00'); 1 row affected (0.004 seconds) 0: jdbc:phoenix:localhost:52919> select * from test.table_with_varchar where id not in (select id from test.table_with_char); ++ | ID | ++ | 00 | ++ 1 row selected (0.109 seconds) 0: jdbc:phoenix:localhost:52919> UPSERT INTO TEST.TABLE_WITH_CHAR(ID) VALUES ('ABC'); 1 row affected (0.005 seconds) 0: jdbc:phoenix:localhost:52919> UPSERT INTO TEST.TABLE_WITH_VARCHAR(ID) VALUES ('ABC'); 1 row affected (0.006 seconds) 0: jdbc:phoenix:localhost:52919> select * from test.table_with_varchar where id not in (select id from test.table_with_char); ++ | ID | ++ | 00 | | ABC| ++ 2 rows selected (0.026 seconds) 0: jdbc:phoenix:localhost:52919> select * from test.table_with_char; ++ | ID | ++ | 00 | | ABC| ++ 2 rows selected (0.013 seconds) 0: jdbc:phoenix:localhost:52919> select * from test.table_with_varchar; +-
[jira] [Updated] (PHOENIX-6428) Phoenix select subquery doesn't work on VARCHAR and CHAR types
[ https://issues.apache.org/jira/browse/PHOENIX-6428?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sandeep Pal updated PHOENIX-6428: - Description: Phoenix select subquery doesn't work on VARCHAR and CHAR types in two tables when column with type CHAR(n) as value lesser than n bytes. . Steps to reproduce: CREATE TABLE TEST.TABLE_WITH_VARCHAR (ID VARCHAR NOT NULL,CONSTRAINT PK PRIMARY KEY (ID)); CREATE TABLE TEST.TABLE_WITH_CHAR (ID CHAR(15) NOT NULL,CONSTRAINT PK PRIMARY KEY (ID)); UPSERT INTO TEST.TABLE_WITH_VARCHAR(ID) VALUES ('00'); UPSERT INTO TEST.TABLE_WITH_CHAR(ID) VALUES ('00'); select * from test.table_with_varchar where id not in (select id from test.table_with_char); {code:java} 0: jdbc:phoenix:localhost:56632> CREATE TABLE TEST.TABLE_WITH_VARCHAR (ID VARCHAR NOT NULL,CONSTRAINT PK PRIMARY KEY (ID)); No rows affected (2.354 seconds) 0: jdbc:phoenix:localhost:56632> CREATE TABLE TEST.TABLE_WITH_CHAR (ID CHAR(15) NOT NULL,CONSTRAINT PK PRIMARY KEY (ID)); No rows affected (2.254 seconds) 0: jdbc:phoenix:localhost:52919> UPSERT INTO TEST.TABLE_WITH_VARCHAR(ID) VALUES ('00'); 1 row affected (0.041 seconds) 0: jdbc:phoenix:localhost:52919> UPSERT INTO TEST.TABLE_WITH_CHAR(ID) VALUES ('00'); 1 row affected (0.004 seconds) 0: jdbc:phoenix:localhost:52919> select * from test.table_with_varchar where id not in (select id from test.table_with_char); ++ | ID | ++ | 00 | ++ 1 row selected (0.109 seconds) 0: jdbc:phoenix:localhost:52919> UPSERT INTO TEST.TABLE_WITH_CHAR(ID) VALUES ('ABC'); 1 row affected (0.005 seconds) 0: jdbc:phoenix:localhost:52919> UPSERT INTO TEST.TABLE_WITH_VARCHAR(ID) VALUES ('ABC'); 1 row affected (0.006 seconds) 0: jdbc:phoenix:localhost:52919> select * from test.table_with_varchar where id not in (select id from test.table_with_char); ++ | ID | ++ | 00 | | ABC| ++ 2 rows selected (0.026 seconds) 0: jdbc:phoenix:localhost:52919> select * from test.table_with_char; ++ | ID | ++ | 00 | | ABC| ++ 2 rows selected (0.013 seconds) 0: jdbc:phoenix:localhost:52919> select * from test.table_with_varchar; ++ | ID | ++ | 00 | | ABC| ++ 2 rows selected (0.011 seconds) 0: jdbc:phoenix:localhost:52919> select * from test.table_with_varchar where id in (select id from test.table_with_char); ++ | ID | ++ ++{code} This returns empty. was: Phoenix select subquery doesn't work on VARCHAR and CHAR types in two tables. Steps to reproduce: CREATE TABLE TEST.TABLE_WITH_VARCHAR (ID VARCHAR NOT NULL,CONSTRAINT PK PRIMARY KEY (ID)); CREATE TABLE TEST.TABLE_WITH_CHAR (ID CHAR(15) NOT NULL,CONSTRAINT PK PRIMARY KEY (ID)); UPSERT INTO TEST.TABLE_WITH_VARCHAR(ID) VALUES ('000'); UPSERT INTO TEST.TABLE_WITH_CHAR(ID) VALUES ('000'); select * from test.table_with_varchar where id not in (select id from test.table_with_char); {code:java} 0: jdbc:phoenix:localhost:56632> CREATE TABLE TEST.TABLE_WITH_VARCHAR (ID VARCHAR NOT NULL,CONSTRAINT PK PRIMARY KEY (ID)); No rows affected (2.354 seconds) 0: jdbc:phoenix:localhost:56632> CREATE TABLE TEST.TABLE_WITH_CHAR (ID CHAR(15) NOT NULL,CONSTRAINT PK PRIMARY KEY (ID)); No rows affected (2.254 seconds) 0: jdbc:phoenix:localhost:56632> UPSERT INTO TEST.TABLE_WITH_VARCHAR(ID) VALUES ('000'); 1 row affected (0.04 seconds) 0: jdbc:phoenix:localhost:56632> UPSERT INTO TEST.TABLE_WITH_CHAR(ID) VALUES ('000'); 1 row affected (0.005 seconds) 0: jdbc:phoenix:localhost:56632> select * from test.table_with_varchar; +-+ | ID| +-+ | 000 | +-+ 1 row selected (0.032 seconds) 0: jdbc:phoenix:localhost:56632> select * from test.table_with_char; +-+ | ID| +-+ | 000 | +-+ 1 row selected (0.015 seconds) 0: jdbc:phoenix:localhost:56632> select * from test.table_with_varchar where id not in (select id from test.table_with_char); ++ | ID | ++ ++{code} This returns empty. > Phoenix select subquery doesn't work on VARCHAR and CHAR types > -- > > Key: PHOENIX-6428 > URL: https://issues.apache.org/jira/browse/PHOENIX-6428 > Project: Phoenix > Issue Type: Improvement >Affects Versions: 4.14.3, 4.16.0, 4.17.0 >Reporter: Sandeep Pal >Priority: Major > > Phoenix select subquery doesn't work on VARCHAR and CHAR types in two tables > when column with type
[jira] [Updated] (PHOENIX-6428) Phoenix select subquery doesn't work on VARCHAR and CHAR types
[ https://issues.apache.org/jira/browse/PHOENIX-6428?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sandeep Pal updated PHOENIX-6428: - Description: Phoenix select subquery doesn't work on VARCHAR and CHAR types in two tables. Steps to reproduce: CREATE TABLE TEST.TABLE_WITH_VARCHAR (ID VARCHAR NOT NULL,CONSTRAINT PK PRIMARY KEY (ID)); CREATE TABLE TEST.TABLE_WITH_CHAR (ID CHAR(15) NOT NULL,CONSTRAINT PK PRIMARY KEY (ID)); UPSERT INTO TEST.TABLE_WITH_VARCHAR(ID) VALUES ('000'); UPSERT INTO TEST.TABLE_WITH_CHAR(ID) VALUES ('000'); select * from test.table_with_varchar where id not in (select id from test.table_with_char); {code:java} 0: jdbc:phoenix:localhost:56632> CREATE TABLE TEST.TABLE_WITH_VARCHAR (ID VARCHAR NOT NULL,CONSTRAINT PK PRIMARY KEY (ID)); No rows affected (2.354 seconds) 0: jdbc:phoenix:localhost:56632> CREATE TABLE TEST.TABLE_WITH_CHAR (ID CHAR(15) NOT NULL,CONSTRAINT PK PRIMARY KEY (ID)); No rows affected (2.254 seconds) 0: jdbc:phoenix:localhost:56632> UPSERT INTO TEST.TABLE_WITH_VARCHAR(ID) VALUES ('000'); 1 row affected (0.04 seconds) 0: jdbc:phoenix:localhost:56632> UPSERT INTO TEST.TABLE_WITH_CHAR(ID) VALUES ('000'); 1 row affected (0.005 seconds) 0: jdbc:phoenix:localhost:56632> select * from test.table_with_varchar; +-+ | ID| +-+ | 000 | +-+ 1 row selected (0.032 seconds) 0: jdbc:phoenix:localhost:56632> select * from test.table_with_char; +-+ | ID| +-+ | 000 | +-+ 1 row selected (0.015 seconds) 0: jdbc:phoenix:localhost:56632> select * from test.table_with_varchar where id not in (select id from test.table_with_char); ++ | ID | ++ ++{code} This returns empty. was: Phoenix select subquery doesn't work on VARCHAR and CHAR types in two tables. Steps to reproduce: CREATE TABLE TEST.TABLE_WITH_VARCHAR (ID VARCHAR NOT NULL,CONSTRAINT PK PRIMARY KEY (ID)); CREATE TABLE TEST.TABLE_WITH_CHAR (ID CHAR(15) NOT NULL,CONSTRAINT PK PRIMARY KEY (ID)); UPSERT INTO TEST.TABLE_WITH_VARCHAR(ID) VALUES ('000'); UPSERT INTO TEST.TABLE_WITH_CHAR(ID) VALUES ('000'); select * from test.table_varchar as T join test.table_with_char as S on S.ID=T.ID; {code:java} 0: jdbc:phoenix:localhost:56632> CREATE TABLE TEST.TABLE_WITH_VARCHAR (ID VARCHAR NOT NULL,CONSTRAINT PK PRIMARY KEY (ID)); No rows affected (2.354 seconds) 0: jdbc:phoenix:localhost:56632> CREATE TABLE TEST.TABLE_WITH_CHAR (ID CHAR(15) NOT NULL,CONSTRAINT PK PRIMARY KEY (ID)); No rows affected (2.254 seconds) 0: jdbc:phoenix:localhost:56632> UPSERT INTO TEST.TABLE_WITH_VARCHAR(ID) VALUES ('000'); 1 row affected (0.04 seconds) 0: jdbc:phoenix:localhost:56632> UPSERT INTO TEST.TABLE_WITH_CHAR(ID) VALUES ('000'); 1 row affected (0.005 seconds) 0: jdbc:phoenix:localhost:56632> select * from test.table_with_varchar; +-+ | ID| +-+ | 000 | +-+ 1 row selected (0.032 seconds) 0: jdbc:phoenix:localhost:56632> select * from test.table_with_char; +-+ | ID| +-+ | 000 | +-+ 1 row selected (0.015 seconds) 0: jdbc:phoenix:localhost:56632> select * from test.table_with_varchar where id not in (select id from test.table_with_char); ++ | ID | ++ ++{code} This returns empty. > Phoenix select subquery doesn't work on VARCHAR and CHAR types > -- > > Key: PHOENIX-6428 > URL: https://issues.apache.org/jira/browse/PHOENIX-6428 > Project: Phoenix > Issue Type: Improvement >Affects Versions: 4.14.3, 4.16.0, 4.17.0 >Reporter: Sandeep Pal >Priority: Major > > Phoenix select subquery doesn't work on VARCHAR and CHAR types in two tables. > Steps to reproduce: > CREATE TABLE TEST.TABLE_WITH_VARCHAR (ID VARCHAR NOT NULL,CONSTRAINT PK > PRIMARY KEY (ID)); > CREATE TABLE TEST.TABLE_WITH_CHAR (ID CHAR(15) NOT NULL,CONSTRAINT PK PRIMARY > KEY (ID)); > > UPSERT INTO TEST.TABLE_WITH_VARCHAR(ID) VALUES ('000'); > UPSERT INTO TEST.TABLE_WITH_CHAR(ID) VALUES ('000'); > > select * from test.table_with_varchar where id not in (select id from > test.table_with_char); > > {code:java} > 0: jdbc:phoenix:localhost:56632> CREATE TABLE TEST.TABLE_WITH_VARCHAR (ID > VARCHAR NOT NULL,CONSTRAINT PK PRIMARY KEY (ID)); > No rows affected (2.354 seconds) > 0: jdbc:phoenix:localhost:56632> CREATE TABLE TEST.TABLE_WITH_CHAR (ID > CHAR(15) NOT NULL,CONSTRAINT PK PRIMARY KEY (ID)); > No rows affected (2.254 seconds) > 0: jdbc:phoenix:localhost:56632> UPSERT INTO TEST.TABLE_WITH_VARCHAR(ID) > VALUES
[jira] [Updated] (PHOENIX-6428) Phoenix select subquery doesn't work on VARCHAR and CHAR types
[ https://issues.apache.org/jira/browse/PHOENIX-6428?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sandeep Pal updated PHOENIX-6428: - Description: Phoenix select subquery doesn't work on VARCHAR and CHAR types in two tables. Steps to reproduce: CREATE TABLE TEST.TABLE_WITH_VARCHAR (ID VARCHAR NOT NULL,CONSTRAINT PK PRIMARY KEY (ID)); CREATE TABLE TEST.TABLE_WITH_CHAR (ID CHAR(15) NOT NULL,CONSTRAINT PK PRIMARY KEY (ID)); UPSERT INTO TEST.TABLE_WITH_VARCHAR(ID) VALUES ('000'); UPSERT INTO TEST.TABLE_WITH_CHAR(ID) VALUES ('000'); select * from test.table_varchar as T join test.table_with_char as S on S.ID=T.ID; {code:java} 0: jdbc:phoenix:localhost:56632> CREATE TABLE TEST.TABLE_WITH_VARCHAR (ID VARCHAR NOT NULL,CONSTRAINT PK PRIMARY KEY (ID)); No rows affected (2.354 seconds) 0: jdbc:phoenix:localhost:56632> CREATE TABLE TEST.TABLE_WITH_CHAR (ID CHAR(15) NOT NULL,CONSTRAINT PK PRIMARY KEY (ID)); No rows affected (2.254 seconds) 0: jdbc:phoenix:localhost:56632> UPSERT INTO TEST.TABLE_WITH_VARCHAR(ID) VALUES ('000'); 1 row affected (0.04 seconds) 0: jdbc:phoenix:localhost:56632> UPSERT INTO TEST.TABLE_WITH_CHAR(ID) VALUES ('000'); 1 row affected (0.005 seconds) 0: jdbc:phoenix:localhost:56632> select * from test.table_with_varchar; +-+ | ID| +-+ | 000 | +-+ 1 row selected (0.032 seconds) 0: jdbc:phoenix:localhost:56632> select * from test.table_with_char; +-+ | ID| +-+ | 000 | +-+ 1 row selected (0.015 seconds) 0: jdbc:phoenix:localhost:56632> select * from test.table_with_varchar where id not in (select id from test.table_with_char); ++ | ID | ++ ++{code} This returns empty. was: When doing the join on two tables on columns with VARCHAR and CHAR, the join condition doesn't work. Steps to reproduce: CREATE TABLE TEST.TABLE_WITH_VARCHAR (ID VARCHAR NOT NULL,CONSTRAINT PK PRIMARY KEY (ID,)); CREATE TABLE TEST.TABLE_WITH_CHAR (ID CHAR(15) NOT NULL,CONSTRAINT PK PRIMARY KEY (ID)); UPSERT INTO TEST.TABLE_WITH_VARCHAR(ID) VALUES ('000'); UPSERT INTO TEST.TABLE_WITH_CHAR(ID) VALUES ('000'); select * from test.table_varchar as T join test.table_with_char as S on S.ID=T.ID; This returns empty. > Phoenix select subquery doesn't work on VARCHAR and CHAR types > -- > > Key: PHOENIX-6428 > URL: https://issues.apache.org/jira/browse/PHOENIX-6428 > Project: Phoenix > Issue Type: Improvement >Affects Versions: 4.14.3, 4.16.0, 4.17.0 >Reporter: Sandeep Pal >Priority: Major > > Phoenix select subquery doesn't work on VARCHAR and CHAR types in two tables. > Steps to reproduce: > CREATE TABLE TEST.TABLE_WITH_VARCHAR (ID VARCHAR NOT NULL,CONSTRAINT PK > PRIMARY KEY (ID)); > CREATE TABLE TEST.TABLE_WITH_CHAR (ID CHAR(15) NOT NULL,CONSTRAINT PK PRIMARY > KEY (ID)); > > UPSERT INTO TEST.TABLE_WITH_VARCHAR(ID) VALUES ('000'); > UPSERT INTO TEST.TABLE_WITH_CHAR(ID) VALUES ('000'); > > select * from test.table_varchar as T join test.table_with_char as S on > S.ID=T.ID; > > {code:java} > 0: jdbc:phoenix:localhost:56632> CREATE TABLE TEST.TABLE_WITH_VARCHAR (ID > VARCHAR NOT NULL,CONSTRAINT PK PRIMARY KEY (ID)); > No rows affected (2.354 seconds) > 0: jdbc:phoenix:localhost:56632> CREATE TABLE TEST.TABLE_WITH_CHAR (ID > CHAR(15) NOT NULL,CONSTRAINT PK PRIMARY KEY (ID)); > No rows affected (2.254 seconds) > 0: jdbc:phoenix:localhost:56632> UPSERT INTO TEST.TABLE_WITH_VARCHAR(ID) > VALUES ('000'); > 1 row affected (0.04 seconds) > 0: jdbc:phoenix:localhost:56632> UPSERT INTO TEST.TABLE_WITH_CHAR(ID) VALUES > ('000'); > 1 row affected (0.005 seconds) > 0: jdbc:phoenix:localhost:56632> select * from test.table_with_varchar; > +-+ > | ID| > +-+ > | 000 | > +-+ > 1 row selected (0.032 seconds) > 0: jdbc:phoenix:localhost:56632> select * from test.table_with_char; > +-+ > | ID| > +-+ > | 000 | > +-+ > 1 row selected (0.015 seconds) > 0: jdbc:phoenix:localhost:56632> select * from test.table_with_varchar where > id not in (select id from test.table_with_char); > ++ > | ID | > ++ > ++{code} > This returns empty. > -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Updated] (PHOENIX-6428) Phoenix select subquery doesn't work on VARCHAR and CHAR types
[ https://issues.apache.org/jira/browse/PHOENIX-6428?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sandeep Pal updated PHOENIX-6428: - Summary: Phoenix select subquery doesn't work on VARCHAR and CHAR types (was: Join on columns with VARCHAR and CHAR types doesn't work) > Phoenix select subquery doesn't work on VARCHAR and CHAR types > -- > > Key: PHOENIX-6428 > URL: https://issues.apache.org/jira/browse/PHOENIX-6428 > Project: Phoenix > Issue Type: Improvement >Affects Versions: 4.14.3, 4.16.0, 4.17.0 >Reporter: Sandeep Pal >Priority: Major > > When doing the join on two tables on columns with VARCHAR and CHAR, the join > condition doesn't work. > Steps to reproduce: > CREATE TABLE TEST.TABLE_WITH_VARCHAR (ID VARCHAR NOT NULL,CONSTRAINT PK > PRIMARY KEY (ID,)); > CREATE TABLE TEST.TABLE_WITH_CHAR (ID CHAR(15) NOT NULL,CONSTRAINT PK PRIMARY > KEY (ID)); > > UPSERT INTO TEST.TABLE_WITH_VARCHAR(ID) VALUES ('000'); > UPSERT INTO TEST.TABLE_WITH_CHAR(ID) VALUES ('000'); > > select * from test.table_varchar as T join test.table_with_char as S on > S.ID=T.ID; > > This returns empty. > -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Updated] (PHOENIX-6428) Join on columns with VARCHAR and CHAR types doesn't work
[ https://issues.apache.org/jira/browse/PHOENIX-6428?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sandeep Pal updated PHOENIX-6428: - Description: When doing the join on two tables on columns with VARCHAR and CHAR, the join condition doesn't work. Steps to reproduce: CREATE TABLE TEST.TABLE_WITH_VARCHAR (ID VARCHAR NOT NULL,CONSTRAINT PK PRIMARY KEY (ID,)); CREATE TABLE TEST.TABLE_WITH_CHAR (ID CHAR(15) NOT NULL,CONSTRAINT PK PRIMARY KEY (ID)); UPSERT INTO TEST.TABLE_WITH_VARCHAR(ID) VALUES ('000'); UPSERT INTO TEST.TABLE_WITH_CHAR(ID) VALUES ('000'); select * from test.table_varchar as T join test.table_with_char as S on S.ID=T.ID; This returns empty. was: When doing the join on two tables on columns with VARCHAR and CHAR, the join condition doesn't work. Steps to reproduce: CREATE TABLE TEST.TABLE_WITH_VARCHAR (ID VARCHAR NOT NULL,CONSTRAINT PK PRIMARY KEY (ID,)); CREATE TABLE TEST.TABLE_WITH_CHAR (ID CHAR(15) NOT NULL,CONSTRAINT PK PRIMARY KEY (ID)); UPSERT INTO TEST.TABLE_WITH_VARCHAR(ID) VALUES ('ABC'); UPSERT INTO TEST.TABLE_WITH_CHAR(ID) VALUES ('ABC'); select * from test.table_varchar as T join test.table_with_char as S on S.ID=T.ID; This returns empty. > Join on columns with VARCHAR and CHAR types doesn't work > > > Key: PHOENIX-6428 > URL: https://issues.apache.org/jira/browse/PHOENIX-6428 > Project: Phoenix > Issue Type: Improvement >Affects Versions: 4.14.3, 4.16.0, 4.17.0 >Reporter: Sandeep Pal >Priority: Major > > When doing the join on two tables on columns with VARCHAR and CHAR, the join > condition doesn't work. > Steps to reproduce: > CREATE TABLE TEST.TABLE_WITH_VARCHAR (ID VARCHAR NOT NULL,CONSTRAINT PK > PRIMARY KEY (ID,)); > CREATE TABLE TEST.TABLE_WITH_CHAR (ID CHAR(15) NOT NULL,CONSTRAINT PK PRIMARY > KEY (ID)); > > UPSERT INTO TEST.TABLE_WITH_VARCHAR(ID) VALUES ('000'); > UPSERT INTO TEST.TABLE_WITH_CHAR(ID) VALUES ('000'); > > select * from test.table_varchar as T join test.table_with_char as S on > S.ID=T.ID; > > This returns empty. > -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Resolved] (PHOENIX-6118) Multi Tenant Workloads using PHERF
[ https://issues.apache.org/jira/browse/PHOENIX-6118?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Xinyi Yan resolved PHOENIX-6118. Resolution: Fixed Thanks for the PR! > Multi Tenant Workloads using PHERF > -- > > Key: PHOENIX-6118 > URL: https://issues.apache.org/jira/browse/PHOENIX-6118 > Project: Phoenix > Issue Type: Sub-task >Reporter: Jacob Isaac >Assignee: Jacob Isaac >Priority: Major > Time Spent: 3h 50m > Remaining Estimate: 0h > > Features like PHOENIX_TTL and Splittable SYSCAT need to be tested for a large > number of tenant views. > In the absence of support for creating a large number of tenant views - Multi > leveled views dynamically and be able to query them in a generic framework, > the teams have to write custom logic to replay/run functional and perf > testing. -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Created] (PHOENIX-6428) Join on columns with VARCHAR and CHAR types doesn't work
Sandeep Pal created PHOENIX-6428: Summary: Join on columns with VARCHAR and CHAR types doesn't work Key: PHOENIX-6428 URL: https://issues.apache.org/jira/browse/PHOENIX-6428 Project: Phoenix Issue Type: Improvement Affects Versions: 4.16.0, 4.14.3, 4.17.0 Reporter: Sandeep Pal When doing the join on two tables on columns with VARCHAR and CHAR, the join condition doesn't work. Steps to reproduce: CREATE TABLE TEST.TABLE_WITH_VARCHAR (ID VARCHAR NOT NULL,CONSTRAINT PK PRIMARY KEY (ID,)); CREATE TABLE TEST.TABLE_WITH_CHAR (ID CHAR(15) NOT NULL,CONSTRAINT PK PRIMARY KEY (ID)); UPSERT INTO TEST.TABLE_WITH_VARCHAR(ID) VALUES ('ABC'); UPSERT INTO TEST.TABLE_WITH_CHAR(ID) VALUES ('ABC'); select * from test.table_varchar as T join test.table_with_char as S on S.ID=T.ID; This returns empty. -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Resolved] (PHOENIX-6398) Returns uniform SQL dialect in calcite for the PQS
[ https://issues.apache.org/jira/browse/PHOENIX-6398?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Istvan Toth resolved PHOENIX-6398. -- Fix Version/s: (was: 4.16.1) queryserver-6.0.0 Resolution: Fixed Committed to master. Thank you for the patch [~luoc]. > Returns uniform SQL dialect in calcite for the PQS > -- > > Key: PHOENIX-6398 > URL: https://issues.apache.org/jira/browse/PHOENIX-6398 > Project: Phoenix > Issue Type: Improvement > Components: queryserver >Reporter: Cong Luo >Assignee: Cong Luo >Priority: Major > Fix For: queryserver-6.0.0 > > > database name in core module > {code:java} > @Override > public String getDatabaseProductName() throws SQLException { > return "Phoenix"; > }{code} > database name in PQS module > {code:java} > return DriverVersion.load( > Driver.class, > "org-apache-phoenix-remote-jdbc.properties", > "Phoenix Remote JDBC Driver", > "unknown version", > "Apache Phoenix", > "unknown version"); > {code} > In result, Calcite could not create `SqlDialect` for PQS. > {code:java} > case "ORACLE": > return new OracleSqlDialect(c); > case "PHOENIX": > return new PhoenixSqlDialect(c); > .{code} > -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Updated] (PHOENIX-6357) Change all command line tools to use the fixed commons-cli constructor
[ https://issues.apache.org/jira/browse/PHOENIX-6357?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Istvan Toth updated PHOENIX-6357: - Summary: Change all command line tools to use the fixed commons-cli constructor (was: Change all command line tools to use the fixed commons-it constructor) > Change all command line tools to use the fixed commons-cli constructor > -- > > Key: PHOENIX-6357 > URL: https://issues.apache.org/jira/browse/PHOENIX-6357 > Project: Phoenix > Issue Type: Improvement > Components: core >Reporter: Istvan Toth >Assignee: Istvan Toth >Priority: Major > > Creating DefaultParser with the new DefaultParser(true, false) or > DefaultParser(false, false) > constructors will not mangle the double quotes for our tools. > Change all tools to use that. -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Assigned] (PHOENIX-6357) Change all command line tools to use the fixed commons-it constructor
[ https://issues.apache.org/jira/browse/PHOENIX-6357?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Istvan Toth reassigned PHOENIX-6357: Assignee: Istvan Toth > Change all command line tools to use the fixed commons-it constructor > - > > Key: PHOENIX-6357 > URL: https://issues.apache.org/jira/browse/PHOENIX-6357 > Project: Phoenix > Issue Type: Improvement > Components: core >Reporter: Istvan Toth >Assignee: Istvan Toth >Priority: Major > > Creating DefaultParser with the new DefaultParser(true, false) or > DefaultParser(false, false) > constructors will not mangle the double quotes for our tools. > Change all tools to use that. -- This message was sent by Atlassian Jira (v8.3.4#803005)
[ANNOUNCE] Apache Phoenix 5.1.1 released
Hello Everyone, The Apache Phoenix team is pleased to announce the immediate availability of the 5.1.1 release. Apache Phoenix enables SQL-based OLTP and operational analytics for Apache Hadoop using Apache HBase as its backing store and providing integration with other projects in the Apache ecosystem such as Spark, Hive, Pig, Flume, and MapReduce. This release has the following improvements: - Fixes for regressions affecting local indexes - Fix for a regression affecting bulk loading into indexed tables - Fix for maven packaging problems - Support for HBase 2.4.1 - Miscellaneous fixes Download source and binaries here [1]. Thanks, Istvan Toth (on behalf of the Apache Phoenix team) [1] http://phoenix.apache.org/download.html