If you setup a netezza server with case sensitivity ON and create a table with upper and lower case characters the extraction for the distribution clause is not taking the case into account. Extract Table Class. Case Sensitivity is already tracked so just need to check and correctly implement the extraction.
Code fixes made. Need to configure case sensitivity ON and OFF Netezza servers and test the create/script of tables and its distribution clause. The code changes only affects the distribution information extraction.
There were multiple issues here. The customer created DISTRIBUTE ON RANDOM and not on any of the table columns we are still not scripting it back. Need to check if this is a default. Also if there are more options on DISTRIBUTE. For e.g.
CREATE TABLE CUST_TEST
(
TEST CHARACTER VARYING(10)
)
DISTRIBUTE ON RANDOM
GO
There were multiple issues here. The customer created DISTRIBUTE ON RANDOM and not on any of the table columns we are still not scripting it back. Need to check if this is a default. Also if there are more options on DISTRIBUTE. For e.g.
CREATE TABLE CUST_TEST
(
TEST CHARACTER VARYING(10)
)
DISTRIBUTE ON RANDOM
GO
OK, I am not sure about "DISTRIBUTE ON RANDOM." Looking into it as it isn't been stored in the catalog tables that we where extracting the distribute on information from.
OK, I am not sure about "DISTRIBUTE ON RANDOM." Looking into it as it isn't been stored in the catalog tables that we where extracting the distribute on information from.
Types of DISTRIBUTION - RANDOM and HASH(columns)
CREATE TABLE CUST_TEST_RAND (
TEST VARCHAR(10) NULL
)
DISTRIBUTE ON RANDOM
GO
CREATE TABLE CUST_TEST_HASH (
TEST VARCHAR(10) NULL
)
DISTRIBUTE ON HASH(TEST)
GO
Types of DISTRIBUTION - RANDOM and HASH(columns)
CREATE TABLE CUST_TEST_RAND (
TEST VARCHAR(10) NULL
)
DISTRIBUTE ON RANDOM
GO
CREATE TABLE CUST_TEST_HASH (
TEST VARCHAR(10) NULL
)
DISTRIBUTE ON HASH(TEST)
GO
Changes have been made to extraction to capture this data. The documentation for netezza is very limited so we have to assume that a value of 6005 in the reldistmethod column of _v_table table represents distributed by random. Need to test this with the server distribution settings modified to different scenarios. Extract/Script fixed.
Handling this new data forces changes to the table dialog storage tab GUI for netezza and should be tested
Changes have been made to extraction to capture this data. The documentation for netezza is very limited so we have to assume that a value of 6005 in the reldistmethod column of _v_table table represents distributed by random. Need to test this with the server distribution settings modified to different scenarios. Extract/Script fixed.
Handling this new data forces changes to the table dialog storage tab GUI for netezza and should be tested
@ Tariq,
Build Date: 2013-Dec-10 05:30:49 PM
Types of DISTRIBUTION - RANDOM and HASH(columns)
CREATE TABLE CUST_TEST_RAND (
TEST VARCHAR(10) NULL
)
DISTRIBUTE ON RANDOM
GO
CREATE TABLE CUST_TEST_HASH (
TEST VARCHAR(10) NULL
)
DISTRIBUTE ON HASH(TEST)
GO
@ Tariq,
Build Date: 2013-Dec-10 05:30:49 PM
Types of DISTRIBUTION - RANDOM and HASH(columns)
CREATE TABLE CUST_TEST_RAND (
TEST VARCHAR(10) NULL
)
DISTRIBUTE ON RANDOM
GO
CREATE TABLE CUST_TEST_HASH (
TEST VARCHAR(10) NULL
)
DISTRIBUTE ON HASH(TEST)
GO
When random property added I forgot to initialize it. Also fixed script table so if its blank it will not script a distribute on ("") clause.
When random property added I forgot to initialize it. Also fixed script table so if its blank it will not script a distribute on ("") clause.
I am not able to reproduce the issue in 14.0.6 with the Null Pointer Exception.
Will talk with Ivan and verify what he has fixed and steps to reproduce.
I am not able to reproduce the issue in 14.0.6 with the Null Pointer Exception.
Will talk with Ivan and verify what he has fixed and steps to reproduce.
Issue #10784 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
Fixed Build v14.0.6-2 |
No time estimate |
Code fixes made. Need to configure case sensitivity ON and OFF Netezza servers and test the create/script of tables and its distribution clause. The code changes only affects the distribution information extraction.