[jira] [Updated] (IMPALA-7347) Assertion Failure - test_show_create_table

2018-07-31 Thread David Knupp (JIRA) 


 [ 
https://issues.apache.org/jira/browse/IMPALA-7347?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

David Knupp updated IMPALA-7347:

Affects Version/s: (was: Impala 3.0)
   Impala 3.1.0

> Assertion Failure - test_show_create_table 
> ---
>
> Key: IMPALA-7347
> URL: https://issues.apache.org/jira/browse/IMPALA-7347
> Project: IMPALA
>  Issue Type: Bug
>Affects Versions: Impala 3.1.0
>Reporter: nithya
>Assignee: Tianyi Wang
>Priority: Blocker
>  Labels: build-failure
>
> test_show_create_table in metadata/test_show_create_table.py is failing with 
> the following assertion error
> {noformat}
> metadata/test_show_create_table.py:58: in test_show_create_table
> unique_database)
> metadata/test_show_create_table.py:106: in __run_show_create_table_test_case
> self.__compare_result(expected_result, create_table_result)
> metadata/test_show_create_table.py:134: in __compare_result
> assert expected_tbl_props == actual_tbl_props
> E   assert {} == {'numFilesErasureCoded': '0'}
> E Right contains more items:
> E {'numFilesErasureCoded': '0'}
> E Use -v to get the full diff
> {noformat}
>  
> It appears that table property "numFilesErasureCoded" is showing up in table 
> properties.
> Either the test needs updating or a bug.
>  
> {code}
> h3. Error Message
> metadata/test_show_create_table.py:58: in test_show_create_table 
> unique_database) metadata/test_show_create_table.py:106: in 
> __run_show_create_table_test_case self.__compare_result(expected_result, 
> create_table_result) metadata/test_show_create_table.py:134: in 
> __compare_result assert expected_tbl_props == actual_tbl_props E assert {} == 
> \{'numFilesErasureCoded': '0'} E Right contains more items: E 
> \{'numFilesErasureCoded': '0'} E Use -v to get the full diff
> {code}
>  
> ---
> {code}
> h3. Standard Error
> -- connecting to: localhost:21000 SET sync_ddl=False; -- executing against 
> localhost:21000 DROP DATABASE IF EXISTS `test_show_create_table_f1598d0b` 
> CASCADE; SET sync_ddl=False; -- executing against localhost:21000 CREATE 
> DATABASE `test_show_create_table_f1598d0b`; MainThread: Created database 
> "test_show_create_table_f1598d0b" for test ID 
> "metadata/test_show_create_table.py::TestShowCreateTable::()::test_show_create_table[table_format:
>  text/none]" -- executing against localhost:21000 CREATE TABLE 
> test_show_create_table_f1598d0b.test1 ( id INT ) STORED AS TEXTFILE; -- 
> executing against localhost:21000 show create table 
> test_show_create_table_f1598d0b.test1; -- executing against localhost:21000 
> drop table test_show_create_table_f1598d0b.test1; -- executing against 
> localhost:21000 CREATE TABLE test_show_create_table_f1598d0b.test1 (id INT) 
> STORED AS TEXTFILE LOCATION 
> 'hdfs://localhost:20500/test-warehouse/test_show_create_table_f1598d0b.db/test1';
>  -- executing against localhost:21000 show create table 
> test_show_create_table_f1598d0b.test1; -- executing against localhost:21000 
> drop table test_show_create_table_f1598d0b.test1; -- executing against 
> localhost:21000 CREATE TABLE test_show_create_table_f1598d0b.test2 ( year 
> INT, month INT, id INT COMMENT 'Add a comment', bool_col BOOLEAN, tinyint_col 
> TINYINT, smallint_col SMALLINT, int_col INT, bigint_col BIGINT, float_col 
> FLOAT, double_col DOUBLE, date_string_col STRING, string_col STRING, 
> timestamp_col TIMESTAMP ) STORED AS TEXTFILE; -- executing against 
> localhost:21000 show create table test_show_create_table_f1598d0b.test2; -- 
> executing against localhost:21000 drop table 
> test_show_create_table_f1598d0b.test2; -- executing against localhost:21000 
> CREATE TABLE test_show_create_table_f1598d0b.test2 (year INT, month INT, id 
> INT COMMENT 'Add a comment', bool_col BOOLEAN, tinyint_col TINYINT, 
> smallint_col SMALLINT, int_col INT, bigint_col BIGINT, float_col FLOAT, 
> double_col DOUBLE, date_string_col STRING, string_col STRING, timestamp_col 
> TIMESTAMP) STORED AS TEXTFILE LOCATION 
> 'hdfs://localhost:20500/test-warehouse/test_show_create_table_f1598d0b.db/test2';
>  -- executing against localhost:21000 show create table 
> test_show_create_table_f1598d0b.test2; -- executing against localhost:21000 
> drop table test_show_create_table_f1598d0b.test2; -- executing against 
> localhost:21000 CREATE TABLE test_show_create_table_f1598d0b.test3 ( year 
> INT, month INT, id INT COMMENT 'Add a comment', bool_col BOOLEAN, tinyint_col 
> TINYINT, smallint_col SMALLINT, int_col INT, bigint_col BIGINT, float_col 
> FLOAT, double_col DOUBLE, date_string_col STRING, string_col STRING, 
> timestamp_col TIMESTAMP ) PARTITIONED BY ( x INT, y INT, a BOOLEAN ) COMMENT 
> 'This is a test' STORED AS TEXTFILE; -- executing against localhost:21000 
> show create table

[jira] [Updated] (IMPALA-7347) Assertion Failure - test_show_create_table

2018-07-31 Thread David Knupp (JIRA) 


 [ 
https://issues.apache.org/jira/browse/IMPALA-7347?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

David Knupp updated IMPALA-7347:

Issue Type: Bug  (was: Test)

> Assertion Failure - test_show_create_table 
> ---
>
> Key: IMPALA-7347
> URL: https://issues.apache.org/jira/browse/IMPALA-7347
> Project: IMPALA
>  Issue Type: Bug
>Affects Versions: Impala 3.0
>Reporter: nithya
>Assignee: Tianyi Wang
>Priority: Blocker
>  Labels: build-failure
>
> test_show_create_table in metadata/test_show_create_table.py is failing with 
> the following assertion error
> {noformat}
> metadata/test_show_create_table.py:58: in test_show_create_table
> unique_database)
> metadata/test_show_create_table.py:106: in __run_show_create_table_test_case
> self.__compare_result(expected_result, create_table_result)
> metadata/test_show_create_table.py:134: in __compare_result
> assert expected_tbl_props == actual_tbl_props
> E   assert {} == {'numFilesErasureCoded': '0'}
> E Right contains more items:
> E {'numFilesErasureCoded': '0'}
> E Use -v to get the full diff
> {noformat}
>  
> It appears that table property "numFilesErasureCoded" is showing up in table 
> properties.
> Either the test needs updating or a bug.
>  
> {code}
> h3. Error Message
> metadata/test_show_create_table.py:58: in test_show_create_table 
> unique_database) metadata/test_show_create_table.py:106: in 
> __run_show_create_table_test_case self.__compare_result(expected_result, 
> create_table_result) metadata/test_show_create_table.py:134: in 
> __compare_result assert expected_tbl_props == actual_tbl_props E assert {} == 
> \{'numFilesErasureCoded': '0'} E Right contains more items: E 
> \{'numFilesErasureCoded': '0'} E Use -v to get the full diff
> {code}
>  
> ---
> {code}
> h3. Standard Error
> -- connecting to: localhost:21000 SET sync_ddl=False; -- executing against 
> localhost:21000 DROP DATABASE IF EXISTS `test_show_create_table_f1598d0b` 
> CASCADE; SET sync_ddl=False; -- executing against localhost:21000 CREATE 
> DATABASE `test_show_create_table_f1598d0b`; MainThread: Created database 
> "test_show_create_table_f1598d0b" for test ID 
> "metadata/test_show_create_table.py::TestShowCreateTable::()::test_show_create_table[table_format:
>  text/none]" -- executing against localhost:21000 CREATE TABLE 
> test_show_create_table_f1598d0b.test1 ( id INT ) STORED AS TEXTFILE; -- 
> executing against localhost:21000 show create table 
> test_show_create_table_f1598d0b.test1; -- executing against localhost:21000 
> drop table test_show_create_table_f1598d0b.test1; -- executing against 
> localhost:21000 CREATE TABLE test_show_create_table_f1598d0b.test1 (id INT) 
> STORED AS TEXTFILE LOCATION 
> 'hdfs://localhost:20500/test-warehouse/test_show_create_table_f1598d0b.db/test1';
>  -- executing against localhost:21000 show create table 
> test_show_create_table_f1598d0b.test1; -- executing against localhost:21000 
> drop table test_show_create_table_f1598d0b.test1; -- executing against 
> localhost:21000 CREATE TABLE test_show_create_table_f1598d0b.test2 ( year 
> INT, month INT, id INT COMMENT 'Add a comment', bool_col BOOLEAN, tinyint_col 
> TINYINT, smallint_col SMALLINT, int_col INT, bigint_col BIGINT, float_col 
> FLOAT, double_col DOUBLE, date_string_col STRING, string_col STRING, 
> timestamp_col TIMESTAMP ) STORED AS TEXTFILE; -- executing against 
> localhost:21000 show create table test_show_create_table_f1598d0b.test2; -- 
> executing against localhost:21000 drop table 
> test_show_create_table_f1598d0b.test2; -- executing against localhost:21000 
> CREATE TABLE test_show_create_table_f1598d0b.test2 (year INT, month INT, id 
> INT COMMENT 'Add a comment', bool_col BOOLEAN, tinyint_col TINYINT, 
> smallint_col SMALLINT, int_col INT, bigint_col BIGINT, float_col FLOAT, 
> double_col DOUBLE, date_string_col STRING, string_col STRING, timestamp_col 
> TIMESTAMP) STORED AS TEXTFILE LOCATION 
> 'hdfs://localhost:20500/test-warehouse/test_show_create_table_f1598d0b.db/test2';
>  -- executing against localhost:21000 show create table 
> test_show_create_table_f1598d0b.test2; -- executing against localhost:21000 
> drop table test_show_create_table_f1598d0b.test2; -- executing against 
> localhost:21000 CREATE TABLE test_show_create_table_f1598d0b.test3 ( year 
> INT, month INT, id INT COMMENT 'Add a comment', bool_col BOOLEAN, tinyint_col 
> TINYINT, smallint_col SMALLINT, int_col INT, bigint_col BIGINT, float_col 
> FLOAT, double_col DOUBLE, date_string_col STRING, string_col STRING, 
> timestamp_col TIMESTAMP ) PARTITIONED BY ( x INT, y INT, a BOOLEAN ) COMMENT 
> 'This is a test' STORED AS TEXTFILE; -- executing against localhost:21000 
> show create table test_show_create_table_f1598d0b.test3; -- executing against 
>

[jira] [Updated] (IMPALA-7347) Assertion Failure - test_show_create_table

2018-07-30 Thread David Knupp (JIRA) 


 [ 
https://issues.apache.org/jira/browse/IMPALA-7347?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

David Knupp updated IMPALA-7347:

Affects Version/s: Impala 3.0

> Assertion Failure - test_show_create_table 
> ---
>
> Key: IMPALA-7347
> URL: https://issues.apache.org/jira/browse/IMPALA-7347
> Project: IMPALA
>  Issue Type: Test
>Affects Versions: Impala 3.0
>Reporter: nithya
>Assignee: Tianyi Wang
>Priority: Blocker
>  Labels: build-failure
>
> test_show_create_table in metadata/test_show_create_table.py is failing with 
> the following assertion error
> {noformat}
> metadata/test_show_create_table.py:58: in test_show_create_table
> unique_database)
> metadata/test_show_create_table.py:106: in __run_show_create_table_test_case
> self.__compare_result(expected_result, create_table_result)
> metadata/test_show_create_table.py:134: in __compare_result
> assert expected_tbl_props == actual_tbl_props
> E   assert {} == {'numFilesErasureCoded': '0'}
> E Right contains more items:
> E {'numFilesErasureCoded': '0'}
> E Use -v to get the full diff
> {noformat}
>  
> It appears that table property "numFilesErasureCoded" is showing up in table 
> properties.
> Either the test needs updating or a bug.
>  
> {code}
> h3. Error Message
> metadata/test_show_create_table.py:58: in test_show_create_table 
> unique_database) metadata/test_show_create_table.py:106: in 
> __run_show_create_table_test_case self.__compare_result(expected_result, 
> create_table_result) metadata/test_show_create_table.py:134: in 
> __compare_result assert expected_tbl_props == actual_tbl_props E assert {} == 
> \{'numFilesErasureCoded': '0'} E Right contains more items: E 
> \{'numFilesErasureCoded': '0'} E Use -v to get the full diff
> {code}
>  
> ---
> {code}
> h3. Standard Error
> -- connecting to: localhost:21000 SET sync_ddl=False; -- executing against 
> localhost:21000 DROP DATABASE IF EXISTS `test_show_create_table_f1598d0b` 
> CASCADE; SET sync_ddl=False; -- executing against localhost:21000 CREATE 
> DATABASE `test_show_create_table_f1598d0b`; MainThread: Created database 
> "test_show_create_table_f1598d0b" for test ID 
> "metadata/test_show_create_table.py::TestShowCreateTable::()::test_show_create_table[table_format:
>  text/none]" -- executing against localhost:21000 CREATE TABLE 
> test_show_create_table_f1598d0b.test1 ( id INT ) STORED AS TEXTFILE; -- 
> executing against localhost:21000 show create table 
> test_show_create_table_f1598d0b.test1; -- executing against localhost:21000 
> drop table test_show_create_table_f1598d0b.test1; -- executing against 
> localhost:21000 CREATE TABLE test_show_create_table_f1598d0b.test1 (id INT) 
> STORED AS TEXTFILE LOCATION 
> 'hdfs://localhost:20500/test-warehouse/test_show_create_table_f1598d0b.db/test1';
>  -- executing against localhost:21000 show create table 
> test_show_create_table_f1598d0b.test1; -- executing against localhost:21000 
> drop table test_show_create_table_f1598d0b.test1; -- executing against 
> localhost:21000 CREATE TABLE test_show_create_table_f1598d0b.test2 ( year 
> INT, month INT, id INT COMMENT 'Add a comment', bool_col BOOLEAN, tinyint_col 
> TINYINT, smallint_col SMALLINT, int_col INT, bigint_col BIGINT, float_col 
> FLOAT, double_col DOUBLE, date_string_col STRING, string_col STRING, 
> timestamp_col TIMESTAMP ) STORED AS TEXTFILE; -- executing against 
> localhost:21000 show create table test_show_create_table_f1598d0b.test2; -- 
> executing against localhost:21000 drop table 
> test_show_create_table_f1598d0b.test2; -- executing against localhost:21000 
> CREATE TABLE test_show_create_table_f1598d0b.test2 (year INT, month INT, id 
> INT COMMENT 'Add a comment', bool_col BOOLEAN, tinyint_col TINYINT, 
> smallint_col SMALLINT, int_col INT, bigint_col BIGINT, float_col FLOAT, 
> double_col DOUBLE, date_string_col STRING, string_col STRING, timestamp_col 
> TIMESTAMP) STORED AS TEXTFILE LOCATION 
> 'hdfs://localhost:20500/test-warehouse/test_show_create_table_f1598d0b.db/test2';
>  -- executing against localhost:21000 show create table 
> test_show_create_table_f1598d0b.test2; -- executing against localhost:21000 
> drop table test_show_create_table_f1598d0b.test2; -- executing against 
> localhost:21000 CREATE TABLE test_show_create_table_f1598d0b.test3 ( year 
> INT, month INT, id INT COMMENT 'Add a comment', bool_col BOOLEAN, tinyint_col 
> TINYINT, smallint_col SMALLINT, int_col INT, bigint_col BIGINT, float_col 
> FLOAT, double_col DOUBLE, date_string_col STRING, string_col STRING, 
> timestamp_col TIMESTAMP ) PARTITIONED BY ( x INT, y INT, a BOOLEAN ) COMMENT 
> 'This is a test' STORED AS TEXTFILE; -- executing against localhost:21000 
> show create table test_show_create_table_f1598d0b.test3; -- executing against 
>

[jira] [Updated] (IMPALA-7347) Assertion Failure - test_show_create_table

2018-07-30 Thread David Knupp (JIRA) 


 [ 
https://issues.apache.org/jira/browse/IMPALA-7347?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

David Knupp updated IMPALA-7347:

Priority: Blocker  (was: Critical)

> Assertion Failure - test_show_create_table 
> ---
>
> Key: IMPALA-7347
> URL: https://issues.apache.org/jira/browse/IMPALA-7347
> Project: IMPALA
>  Issue Type: Test
>Reporter: nithya
>Assignee: Tianyi Wang
>Priority: Blocker
>  Labels: build-failure
>
> test_show_create_table in metadata/test_show_create_table.py is failing with 
> the following assertion error
> {noformat}
> metadata/test_show_create_table.py:58: in test_show_create_table
> unique_database)
> metadata/test_show_create_table.py:106: in __run_show_create_table_test_case
> self.__compare_result(expected_result, create_table_result)
> metadata/test_show_create_table.py:134: in __compare_result
> assert expected_tbl_props == actual_tbl_props
> E   assert {} == {'numFilesErasureCoded': '0'}
> E Right contains more items:
> E {'numFilesErasureCoded': '0'}
> E Use -v to get the full diff
> {noformat}
>  
> It appears that table property "numFilesErasureCoded" is showing up in table 
> properties.
> Either the test needs updating or a bug.
>  
> {code}
> h3. Error Message
> metadata/test_show_create_table.py:58: in test_show_create_table 
> unique_database) metadata/test_show_create_table.py:106: in 
> __run_show_create_table_test_case self.__compare_result(expected_result, 
> create_table_result) metadata/test_show_create_table.py:134: in 
> __compare_result assert expected_tbl_props == actual_tbl_props E assert {} == 
> \{'numFilesErasureCoded': '0'} E Right contains more items: E 
> \{'numFilesErasureCoded': '0'} E Use -v to get the full diff
> {code}
>  
> ---
> {code}
> h3. Standard Error
> -- connecting to: localhost:21000 SET sync_ddl=False; -- executing against 
> localhost:21000 DROP DATABASE IF EXISTS `test_show_create_table_f1598d0b` 
> CASCADE; SET sync_ddl=False; -- executing against localhost:21000 CREATE 
> DATABASE `test_show_create_table_f1598d0b`; MainThread: Created database 
> "test_show_create_table_f1598d0b" for test ID 
> "metadata/test_show_create_table.py::TestShowCreateTable::()::test_show_create_table[table_format:
>  text/none]" -- executing against localhost:21000 CREATE TABLE 
> test_show_create_table_f1598d0b.test1 ( id INT ) STORED AS TEXTFILE; -- 
> executing against localhost:21000 show create table 
> test_show_create_table_f1598d0b.test1; -- executing against localhost:21000 
> drop table test_show_create_table_f1598d0b.test1; -- executing against 
> localhost:21000 CREATE TABLE test_show_create_table_f1598d0b.test1 (id INT) 
> STORED AS TEXTFILE LOCATION 
> 'hdfs://localhost:20500/test-warehouse/test_show_create_table_f1598d0b.db/test1';
>  -- executing against localhost:21000 show create table 
> test_show_create_table_f1598d0b.test1; -- executing against localhost:21000 
> drop table test_show_create_table_f1598d0b.test1; -- executing against 
> localhost:21000 CREATE TABLE test_show_create_table_f1598d0b.test2 ( year 
> INT, month INT, id INT COMMENT 'Add a comment', bool_col BOOLEAN, tinyint_col 
> TINYINT, smallint_col SMALLINT, int_col INT, bigint_col BIGINT, float_col 
> FLOAT, double_col DOUBLE, date_string_col STRING, string_col STRING, 
> timestamp_col TIMESTAMP ) STORED AS TEXTFILE; -- executing against 
> localhost:21000 show create table test_show_create_table_f1598d0b.test2; -- 
> executing against localhost:21000 drop table 
> test_show_create_table_f1598d0b.test2; -- executing against localhost:21000 
> CREATE TABLE test_show_create_table_f1598d0b.test2 (year INT, month INT, id 
> INT COMMENT 'Add a comment', bool_col BOOLEAN, tinyint_col TINYINT, 
> smallint_col SMALLINT, int_col INT, bigint_col BIGINT, float_col FLOAT, 
> double_col DOUBLE, date_string_col STRING, string_col STRING, timestamp_col 
> TIMESTAMP) STORED AS TEXTFILE LOCATION 
> 'hdfs://localhost:20500/test-warehouse/test_show_create_table_f1598d0b.db/test2';
>  -- executing against localhost:21000 show create table 
> test_show_create_table_f1598d0b.test2; -- executing against localhost:21000 
> drop table test_show_create_table_f1598d0b.test2; -- executing against 
> localhost:21000 CREATE TABLE test_show_create_table_f1598d0b.test3 ( year 
> INT, month INT, id INT COMMENT 'Add a comment', bool_col BOOLEAN, tinyint_col 
> TINYINT, smallint_col SMALLINT, int_col INT, bigint_col BIGINT, float_col 
> FLOAT, double_col DOUBLE, date_string_col STRING, string_col STRING, 
> timestamp_col TIMESTAMP ) PARTITIONED BY ( x INT, y INT, a BOOLEAN ) COMMENT 
> 'This is a test' STORED AS TEXTFILE; -- executing against localhost:21000 
> show create table test_show_create_table_f1598d0b.test3; -- executing against 
> localhost:21000 drop table

[jira] [Updated] (IMPALA-7347) Assertion Failure - test_show_create_table

2018-07-30 Thread David Knupp (JIRA) 


 [ 
https://issues.apache.org/jira/browse/IMPALA-7347?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

David Knupp updated IMPALA-7347:

Description: 
test_show_create_table in metadata/test_show_create_table.py is failing with 
the following assertion error

{noformat}
metadata/test_show_create_table.py:58: in test_show_create_table
unique_database)
metadata/test_show_create_table.py:106: in __run_show_create_table_test_case
self.__compare_result(expected_result, create_table_result)
metadata/test_show_create_table.py:134: in __compare_result
assert expected_tbl_props == actual_tbl_props
E   assert {} == {'numFilesErasureCoded': '0'}
E Right contains more items:
E {'numFilesErasureCoded': '0'}
E Use -v to get the full diff
{noformat}

 

It appears that table property "numFilesErasureCoded" is showing up in table 
properties.

Either the test needs updating or a bug.

 

{code}
h3. Error Message

metadata/test_show_create_table.py:58: in test_show_create_table 
unique_database) metadata/test_show_create_table.py:106: in 
__run_show_create_table_test_case self.__compare_result(expected_result, 
create_table_result) metadata/test_show_create_table.py:134: in 
__compare_result assert expected_tbl_props == actual_tbl_props E assert {} == 
\{'numFilesErasureCoded': '0'} E Right contains more items: E 
\{'numFilesErasureCoded': '0'} E Use -v to get the full diff

{code}

 

---

{code}
h3. Standard Error

-- connecting to: localhost:21000 SET sync_ddl=False; -- executing against 
localhost:21000 DROP DATABASE IF EXISTS `test_show_create_table_f1598d0b` 
CASCADE; SET sync_ddl=False; -- executing against localhost:21000 CREATE 
DATABASE `test_show_create_table_f1598d0b`; MainThread: Created database 
"test_show_create_table_f1598d0b" for test ID 
"metadata/test_show_create_table.py::TestShowCreateTable::()::test_show_create_table[table_format:
 text/none]" -- executing against localhost:21000 CREATE TABLE 
test_show_create_table_f1598d0b.test1 ( id INT ) STORED AS TEXTFILE; -- 
executing against localhost:21000 show create table 
test_show_create_table_f1598d0b.test1; -- executing against localhost:21000 
drop table test_show_create_table_f1598d0b.test1; -- executing against 
localhost:21000 CREATE TABLE test_show_create_table_f1598d0b.test1 (id INT) 
STORED AS TEXTFILE LOCATION 
'hdfs://localhost:20500/test-warehouse/test_show_create_table_f1598d0b.db/test1';
 -- executing against localhost:21000 show create table 
test_show_create_table_f1598d0b.test1; -- executing against localhost:21000 
drop table test_show_create_table_f1598d0b.test1; -- executing against 
localhost:21000 CREATE TABLE test_show_create_table_f1598d0b.test2 ( year INT, 
month INT, id INT COMMENT 'Add a comment', bool_col BOOLEAN, tinyint_col 
TINYINT, smallint_col SMALLINT, int_col INT, bigint_col BIGINT, float_col 
FLOAT, double_col DOUBLE, date_string_col STRING, string_col STRING, 
timestamp_col TIMESTAMP ) STORED AS TEXTFILE; -- executing against 
localhost:21000 show create table test_show_create_table_f1598d0b.test2; -- 
executing against localhost:21000 drop table 
test_show_create_table_f1598d0b.test2; -- executing against localhost:21000 
CREATE TABLE test_show_create_table_f1598d0b.test2 (year INT, month INT, id INT 
COMMENT 'Add a comment', bool_col BOOLEAN, tinyint_col TINYINT, smallint_col 
SMALLINT, int_col INT, bigint_col BIGINT, float_col FLOAT, double_col DOUBLE, 
date_string_col STRING, string_col STRING, timestamp_col TIMESTAMP) STORED AS 
TEXTFILE LOCATION 
'hdfs://localhost:20500/test-warehouse/test_show_create_table_f1598d0b.db/test2';
 -- executing against localhost:21000 show create table 
test_show_create_table_f1598d0b.test2; -- executing against localhost:21000 
drop table test_show_create_table_f1598d0b.test2; -- executing against 
localhost:21000 CREATE TABLE test_show_create_table_f1598d0b.test3 ( year INT, 
month INT, id INT COMMENT 'Add a comment', bool_col BOOLEAN, tinyint_col 
TINYINT, smallint_col SMALLINT, int_col INT, bigint_col BIGINT, float_col 
FLOAT, double_col DOUBLE, date_string_col STRING, string_col STRING, 
timestamp_col TIMESTAMP ) PARTITIONED BY ( x INT, y INT, a BOOLEAN ) COMMENT 
'This is a test' STORED AS TEXTFILE; -- executing against localhost:21000 show 
create table test_show_create_table_f1598d0b.test3; -- executing against 
localhost:21000 drop table test_show_create_table_f1598d0b.test3; -- executing 
against localhost:21000 CREATE TABLE test_show_create_table_f1598d0b.test3 
(year INT, month INT, id INT COMMENT 'Add a comment', bool_col BOOLEAN, 
tinyint_col TINYINT, smallint_col SMALLINT, int_col INT, bigint_col BIGINT, 
float_col FLOAT, double_col DOUBLE, date_string_col STRING, string_col STRING, 
timestamp_col TIMESTAMP) PARTITIONED BY (x INT, y INT, a BOOLEAN) COMMENT 'This 
is a test' STORED AS TEXTFILE LOCATION

[jira] [Updated] (IMPALA-7347) Assertion Failure - test_show_create_table

2018-07-25 Thread nithya (JIRA) 


 [ 
https://issues.apache.org/jira/browse/IMPALA-7347?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

nithya updated IMPALA-7347:
---
Labels: build-failure  (was: )

> Assertion Failure - test_show_create_table 
> ---
>
> Key: IMPALA-7347
> URL: https://issues.apache.org/jira/browse/IMPALA-7347
> Project: IMPALA
>  Issue Type: Test
>Reporter: nithya
>Priority: Major
>  Labels: build-failure
>
> test_show_create_table in metadata/test_show_create_table.py is failing with 
> the following assertion error
> {code}
> metadata/test_show_create_table.py:58: in test_show_create_table 
> unique_database) metadata/test_show_create_table.py:106: in 
> __run_show_create_table_test_case self.__compare_result(expected_result, 
> create_table_result) metadata/test_show_create_table.py:134: in 
> __compare_result assert expected_tbl_props == actual_tbl_props E assert {} == 
> \{'numFilesErasureCoded': '0'} E Right contains more items: E 
> \{'numFilesErasureCoded': '0'} E Use -v to get the full diff
> {code}
>  
> It appears that table property "numFilesErasureCoded" is showing up in table 
> properties.
> Either the test needs updating or a bug.
>  
> {code}
> h3. Error Message
> metadata/test_show_create_table.py:58: in test_show_create_table 
> unique_database) metadata/test_show_create_table.py:106: in 
> __run_show_create_table_test_case self.__compare_result(expected_result, 
> create_table_result) metadata/test_show_create_table.py:134: in 
> __compare_result assert expected_tbl_props == actual_tbl_props E assert {} == 
> \{'numFilesErasureCoded': '0'} E Right contains more items: E 
> \{'numFilesErasureCoded': '0'} E Use -v to get the full diff
> {code}
>  
> ---
> {code}
> h3. Standard Error
> -- connecting to: localhost:21000 SET sync_ddl=False; -- executing against 
> localhost:21000 DROP DATABASE IF EXISTS `test_show_create_table_f1598d0b` 
> CASCADE; SET sync_ddl=False; -- executing against localhost:21000 CREATE 
> DATABASE `test_show_create_table_f1598d0b`; MainThread: Created database 
> "test_show_create_table_f1598d0b" for test ID 
> "metadata/test_show_create_table.py::TestShowCreateTable::()::test_show_create_table[table_format:
>  text/none]" -- executing against localhost:21000 CREATE TABLE 
> test_show_create_table_f1598d0b.test1 ( id INT ) STORED AS TEXTFILE; -- 
> executing against localhost:21000 show create table 
> test_show_create_table_f1598d0b.test1; -- executing against localhost:21000 
> drop table test_show_create_table_f1598d0b.test1; -- executing against 
> localhost:21000 CREATE TABLE test_show_create_table_f1598d0b.test1 (id INT) 
> STORED AS TEXTFILE LOCATION 
> 'hdfs://localhost:20500/test-warehouse/test_show_create_table_f1598d0b.db/test1';
>  -- executing against localhost:21000 show create table 
> test_show_create_table_f1598d0b.test1; -- executing against localhost:21000 
> drop table test_show_create_table_f1598d0b.test1; -- executing against 
> localhost:21000 CREATE TABLE test_show_create_table_f1598d0b.test2 ( year 
> INT, month INT, id INT COMMENT 'Add a comment', bool_col BOOLEAN, tinyint_col 
> TINYINT, smallint_col SMALLINT, int_col INT, bigint_col BIGINT, float_col 
> FLOAT, double_col DOUBLE, date_string_col STRING, string_col STRING, 
> timestamp_col TIMESTAMP ) STORED AS TEXTFILE; -- executing against 
> localhost:21000 show create table test_show_create_table_f1598d0b.test2; -- 
> executing against localhost:21000 drop table 
> test_show_create_table_f1598d0b.test2; -- executing against localhost:21000 
> CREATE TABLE test_show_create_table_f1598d0b.test2 (year INT, month INT, id 
> INT COMMENT 'Add a comment', bool_col BOOLEAN, tinyint_col TINYINT, 
> smallint_col SMALLINT, int_col INT, bigint_col BIGINT, float_col FLOAT, 
> double_col DOUBLE, date_string_col STRING, string_col STRING, timestamp_col 
> TIMESTAMP) STORED AS TEXTFILE LOCATION 
> 'hdfs://localhost:20500/test-warehouse/test_show_create_table_f1598d0b.db/test2';
>  -- executing against localhost:21000 show create table 
> test_show_create_table_f1598d0b.test2; -- executing against localhost:21000 
> drop table test_show_create_table_f1598d0b.test2; -- executing against 
> localhost:21000 CREATE TABLE test_show_create_table_f1598d0b.test3 ( year 
> INT, month INT, id INT COMMENT 'Add a comment', bool_col BOOLEAN, tinyint_col 
> TINYINT, smallint_col SMALLINT, int_col INT, bigint_col BIGINT, float_col 
> FLOAT, double_col DOUBLE, date_string_col STRING, string_col STRING, 
> timestamp_col TIMESTAMP ) PARTITIONED BY ( x INT, y INT, a BOOLEAN ) COMMENT 
> 'This is a test' STORED AS TEXTFILE; -- executing against localhost:21000 
> show create table test_show_create_table_f1598d0b.test3; -- executing against 
> localhost:21000 drop table test_show_create_table_f1598d0b.test3; -- 
> executing against localhost:21000 CREATE

[jira] [Updated] (IMPALA-7347) Assertion Failure - test_show_create_table

2018-07-25 Thread nithya (JIRA) 


 [ 
https://issues.apache.org/jira/browse/IMPALA-7347?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

nithya updated IMPALA-7347:
---
Priority: Critical  (was: Major)

> Assertion Failure - test_show_create_table 
> ---
>
> Key: IMPALA-7347
> URL: https://issues.apache.org/jira/browse/IMPALA-7347
> Project: IMPALA
>  Issue Type: Test
>Reporter: nithya
>Priority: Critical
>  Labels: build-failure
>
> test_show_create_table in metadata/test_show_create_table.py is failing with 
> the following assertion error
> {code}
> metadata/test_show_create_table.py:58: in test_show_create_table 
> unique_database) metadata/test_show_create_table.py:106: in 
> __run_show_create_table_test_case self.__compare_result(expected_result, 
> create_table_result) metadata/test_show_create_table.py:134: in 
> __compare_result assert expected_tbl_props == actual_tbl_props E assert {} == 
> \{'numFilesErasureCoded': '0'} E Right contains more items: E 
> \{'numFilesErasureCoded': '0'} E Use -v to get the full diff
> {code}
>  
> It appears that table property "numFilesErasureCoded" is showing up in table 
> properties.
> Either the test needs updating or a bug.
>  
> {code}
> h3. Error Message
> metadata/test_show_create_table.py:58: in test_show_create_table 
> unique_database) metadata/test_show_create_table.py:106: in 
> __run_show_create_table_test_case self.__compare_result(expected_result, 
> create_table_result) metadata/test_show_create_table.py:134: in 
> __compare_result assert expected_tbl_props == actual_tbl_props E assert {} == 
> \{'numFilesErasureCoded': '0'} E Right contains more items: E 
> \{'numFilesErasureCoded': '0'} E Use -v to get the full diff
> {code}
>  
> ---
> {code}
> h3. Standard Error
> -- connecting to: localhost:21000 SET sync_ddl=False; -- executing against 
> localhost:21000 DROP DATABASE IF EXISTS `test_show_create_table_f1598d0b` 
> CASCADE; SET sync_ddl=False; -- executing against localhost:21000 CREATE 
> DATABASE `test_show_create_table_f1598d0b`; MainThread: Created database 
> "test_show_create_table_f1598d0b" for test ID 
> "metadata/test_show_create_table.py::TestShowCreateTable::()::test_show_create_table[table_format:
>  text/none]" -- executing against localhost:21000 CREATE TABLE 
> test_show_create_table_f1598d0b.test1 ( id INT ) STORED AS TEXTFILE; -- 
> executing against localhost:21000 show create table 
> test_show_create_table_f1598d0b.test1; -- executing against localhost:21000 
> drop table test_show_create_table_f1598d0b.test1; -- executing against 
> localhost:21000 CREATE TABLE test_show_create_table_f1598d0b.test1 (id INT) 
> STORED AS TEXTFILE LOCATION 
> 'hdfs://localhost:20500/test-warehouse/test_show_create_table_f1598d0b.db/test1';
>  -- executing against localhost:21000 show create table 
> test_show_create_table_f1598d0b.test1; -- executing against localhost:21000 
> drop table test_show_create_table_f1598d0b.test1; -- executing against 
> localhost:21000 CREATE TABLE test_show_create_table_f1598d0b.test2 ( year 
> INT, month INT, id INT COMMENT 'Add a comment', bool_col BOOLEAN, tinyint_col 
> TINYINT, smallint_col SMALLINT, int_col INT, bigint_col BIGINT, float_col 
> FLOAT, double_col DOUBLE, date_string_col STRING, string_col STRING, 
> timestamp_col TIMESTAMP ) STORED AS TEXTFILE; -- executing against 
> localhost:21000 show create table test_show_create_table_f1598d0b.test2; -- 
> executing against localhost:21000 drop table 
> test_show_create_table_f1598d0b.test2; -- executing against localhost:21000 
> CREATE TABLE test_show_create_table_f1598d0b.test2 (year INT, month INT, id 
> INT COMMENT 'Add a comment', bool_col BOOLEAN, tinyint_col TINYINT, 
> smallint_col SMALLINT, int_col INT, bigint_col BIGINT, float_col FLOAT, 
> double_col DOUBLE, date_string_col STRING, string_col STRING, timestamp_col 
> TIMESTAMP) STORED AS TEXTFILE LOCATION 
> 'hdfs://localhost:20500/test-warehouse/test_show_create_table_f1598d0b.db/test2';
>  -- executing against localhost:21000 show create table 
> test_show_create_table_f1598d0b.test2; -- executing against localhost:21000 
> drop table test_show_create_table_f1598d0b.test2; -- executing against 
> localhost:21000 CREATE TABLE test_show_create_table_f1598d0b.test3 ( year 
> INT, month INT, id INT COMMENT 'Add a comment', bool_col BOOLEAN, tinyint_col 
> TINYINT, smallint_col SMALLINT, int_col INT, bigint_col BIGINT, float_col 
> FLOAT, double_col DOUBLE, date_string_col STRING, string_col STRING, 
> timestamp_col TIMESTAMP ) PARTITIONED BY ( x INT, y INT, a BOOLEAN ) COMMENT 
> 'This is a test' STORED AS TEXTFILE; -- executing against localhost:21000 
> show create table test_show_create_table_f1598d0b.test3; -- executing against 
> localhost:21000 drop table test_show_create_table_f1598d0b.test3; -- 
> executing against localhost:21000