This is an automated email from the ASF dual-hosted git repository.
abstractdog pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/hive.git
The following commit(s) were added to refs/heads/master by this push:
new 0cc5c337046 HIVE-27294: Remove redundant qt_database_all.q for memory
consumption reasons (#4267) (Laszlo Bodor reviewed by Stamatis Zampetakis)
0cc5c337046 is described below
commit 0cc5c337046e0d81d73f6c228c67c8750bf22594
Author: Bodor Laszlo <[email protected]>
AuthorDate: Tue May 2 23:26:29 2023 +0200
HIVE-27294: Remove redundant qt_database_all.q for memory consumption
reasons (#4267) (Laszlo Bodor reviewed by Stamatis Zampetakis)
---
.../test/queries/clientpositive/qt_database_all.q | 86 --------
.../clientpositive/llap/qt_database_all.q.out | 235 ---------------------
2 files changed, 321 deletions(-)
diff --git a/ql/src/test/queries/clientpositive/qt_database_all.q
b/ql/src/test/queries/clientpositive/qt_database_all.q
deleted file mode 100644
index 969518714db..00000000000
--- a/ql/src/test/queries/clientpositive/qt_database_all.q
+++ /dev/null
@@ -1,86 +0,0 @@
---!qt:database:postgres:q_test_country_table.sql
---!qt:database:mysql:q_test_state_table.sql
---!qt:database:mariadb:q_test_city_table.sql
---!qt:database:mssql:q_test_author_table.sql
---!qt:database:oracle:q_test_book_table.sql
-CREATE EXTERNAL TABLE country
-(
- id int,
- name varchar(20)
-)
-STORED BY 'org.apache.hive.storage.jdbc.JdbcStorageHandler'
-TBLPROPERTIES (
- "hive.sql.database.type" = "POSTGRES",
- "hive.sql.jdbc.driver" = "org.postgresql.Driver",
- "hive.sql.jdbc.url" = "jdbc:postgresql://localhost:5432/qtestDB",
- "hive.sql.dbcp.username" = "qtestuser",
- "hive.sql.dbcp.password" = "qtestpassword",
- "hive.sql.table" = "country"
- );
-SELECT * FROM country;
-
-CREATE EXTERNAL TABLE state
-(
- name varchar(255),
- country int
-)
-STORED BY 'org.apache.hive.storage.jdbc.JdbcStorageHandler'
-TBLPROPERTIES (
- "hive.sql.database.type" = "MYSQL",
- "hive.sql.jdbc.driver" = "com.mysql.jdbc.Driver",
- "hive.sql.jdbc.url" = "jdbc:mysql://localhost:3306/qtestDB",
- "hive.sql.dbcp.username" = "root",
- "hive.sql.dbcp.password" = "qtestpassword",
- "hive.sql.table" = "state"
- );
-SELECT * FROM state;
-
-CREATE EXTERNAL TABLE city
-(
- name varchar(255),
- state int
-)
-STORED BY 'org.apache.hive.storage.jdbc.JdbcStorageHandler'
-TBLPROPERTIES (
- "hive.sql.database.type" = "MYSQL",
- "hive.sql.jdbc.driver" = "org.mariadb.jdbc.Driver",
- "hive.sql.jdbc.url" = "jdbc:mariadb://localhost:3309/qtestDB",
- "hive.sql.dbcp.username" = "root",
- "hive.sql.dbcp.password" = "qtestpassword",
- "hive.sql.table" = "city"
-);
-SELECT * FROM city;
-
-CREATE EXTERNAL TABLE author
-(
- id int,
- fname varchar(20),
- lname varchar(20)
-)
-STORED BY 'org.apache.hive.storage.jdbc.JdbcStorageHandler'
-TBLPROPERTIES (
- "hive.sql.database.type" = "MSSQL",
- "hive.sql.jdbc.driver" = "com.microsoft.sqlserver.jdbc.SQLServerDriver",
- "hive.sql.jdbc.url" = "jdbc:sqlserver://localhost:1433",
- "hive.sql.dbcp.username" = "sa",
- "hive.sql.dbcp.password" = "Its-a-s3cret",
- "hive.sql.table" = "author"
- );
-SELECT * FROM author;
-
-CREATE EXTERNAL TABLE book
-(
- id int,
- title varchar(100),
- author int
-)
- STORED BY 'org.apache.hive.storage.jdbc.JdbcStorageHandler'
- TBLPROPERTIES (
- "hive.sql.database.type" = "ORACLE",
- "hive.sql.jdbc.driver" = "oracle.jdbc.OracleDriver",
- "hive.sql.jdbc.url" = "jdbc:oracle:thin:@//localhost:1521/xe",
- "hive.sql.dbcp.username" = "SYS as SYSDBA",
- "hive.sql.dbcp.password" = "oracle",
- "hive.sql.table" = "BOOK"
- );
-SELECT * FROM book;
diff --git a/ql/src/test/results/clientpositive/llap/qt_database_all.q.out
b/ql/src/test/results/clientpositive/llap/qt_database_all.q.out
deleted file mode 100644
index 2458c318c5c..00000000000
--- a/ql/src/test/results/clientpositive/llap/qt_database_all.q.out
+++ /dev/null
@@ -1,235 +0,0 @@
-PREHOOK: query: CREATE EXTERNAL TABLE country
-(
- id int,
- name varchar(20)
-)
-STORED BY 'org.apache.hive.storage.jdbc.JdbcStorageHandler'
-TBLPROPERTIES (
- "hive.sql.database.type" = "POSTGRES",
- "hive.sql.jdbc.driver" = "org.postgresql.Driver",
- "hive.sql.jdbc.url" = "jdbc:postgresql://localhost:5432/qtestDB",
- "hive.sql.dbcp.username" = "qtestuser",
- "hive.sql.dbcp.password" = "qtestpassword",
- "hive.sql.table" = "country"
- )
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@country
-POSTHOOK: query: CREATE EXTERNAL TABLE country
-(
- id int,
- name varchar(20)
-)
-STORED BY 'org.apache.hive.storage.jdbc.JdbcStorageHandler'
-TBLPROPERTIES (
- "hive.sql.database.type" = "POSTGRES",
- "hive.sql.jdbc.driver" = "org.postgresql.Driver",
- "hive.sql.jdbc.url" = "jdbc:postgresql://localhost:5432/qtestDB",
- "hive.sql.dbcp.username" = "qtestuser",
- "hive.sql.dbcp.password" = "qtestpassword",
- "hive.sql.table" = "country"
- )
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@country
-PREHOOK: query: SELECT * FROM country
-PREHOOK: type: QUERY
-PREHOOK: Input: default@country
-#### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM country
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@country
-#### A masked pattern was here ####
-1 India
-2 Russia
-3 USA
-PREHOOK: query: CREATE EXTERNAL TABLE state
-(
- name varchar(255),
- country int
-)
-STORED BY 'org.apache.hive.storage.jdbc.JdbcStorageHandler'
-TBLPROPERTIES (
- "hive.sql.database.type" = "MYSQL",
- "hive.sql.jdbc.driver" = "com.mysql.jdbc.Driver",
- "hive.sql.jdbc.url" = "jdbc:mysql://localhost:3306/qtestDB",
- "hive.sql.dbcp.username" = "root",
- "hive.sql.dbcp.password" = "qtestpassword",
- "hive.sql.table" = "state"
- )
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@state
-POSTHOOK: query: CREATE EXTERNAL TABLE state
-(
- name varchar(255),
- country int
-)
-STORED BY 'org.apache.hive.storage.jdbc.JdbcStorageHandler'
-TBLPROPERTIES (
- "hive.sql.database.type" = "MYSQL",
- "hive.sql.jdbc.driver" = "com.mysql.jdbc.Driver",
- "hive.sql.jdbc.url" = "jdbc:mysql://localhost:3306/qtestDB",
- "hive.sql.dbcp.username" = "root",
- "hive.sql.dbcp.password" = "qtestpassword",
- "hive.sql.table" = "state"
- )
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@state
-PREHOOK: query: SELECT * FROM state
-PREHOOK: type: QUERY
-PREHOOK: Input: default@state
-#### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM state
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@state
-#### A masked pattern was here ####
-Maharashtra 1
-Madhya Pradesh 1
-Moscow 3
-Something 4
-Florida 4
-Texas 4
-PREHOOK: query: CREATE EXTERNAL TABLE city
-(
- name varchar(255),
- state int
-)
-STORED BY 'org.apache.hive.storage.jdbc.JdbcStorageHandler'
-TBLPROPERTIES (
- "hive.sql.database.type" = "MYSQL",
- "hive.sql.jdbc.driver" = "org.mariadb.jdbc.Driver",
- "hive.sql.jdbc.url" = "jdbc:mariadb://localhost:3309/qtestDB",
- "hive.sql.dbcp.username" = "root",
- "hive.sql.dbcp.password" = "qtestpassword",
- "hive.sql.table" = "city"
-)
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@city
-POSTHOOK: query: CREATE EXTERNAL TABLE city
-(
- name varchar(255),
- state int
-)
-STORED BY 'org.apache.hive.storage.jdbc.JdbcStorageHandler'
-TBLPROPERTIES (
- "hive.sql.database.type" = "MYSQL",
- "hive.sql.jdbc.driver" = "org.mariadb.jdbc.Driver",
- "hive.sql.jdbc.url" = "jdbc:mariadb://localhost:3309/qtestDB",
- "hive.sql.dbcp.username" = "root",
- "hive.sql.dbcp.password" = "qtestpassword",
- "hive.sql.table" = "city"
-)
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@city
-PREHOOK: query: SELECT * FROM city
-PREHOOK: type: QUERY
-PREHOOK: Input: default@city
-#### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM city
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@city
-#### A masked pattern was here ####
-Mumbai 1
-Pune 1
-Bhopal 2
-Indore 2
-Klin 3
-Los Angeles 5
-Plant City 5
-Arlington 6
-PREHOOK: query: CREATE EXTERNAL TABLE author
-(
- id int,
- fname varchar(20),
- lname varchar(20)
-)
-STORED BY 'org.apache.hive.storage.jdbc.JdbcStorageHandler'
-TBLPROPERTIES (
- "hive.sql.database.type" = "MSSQL",
- "hive.sql.jdbc.driver" = "com.microsoft.sqlserver.jdbc.SQLServerDriver",
- "hive.sql.jdbc.url" = "jdbc:sqlserver://localhost:1433",
- "hive.sql.dbcp.username" = "sa",
- "hive.sql.dbcp.password" = "Its-a-s3cret",
- "hive.sql.table" = "author"
- )
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@author
-POSTHOOK: query: CREATE EXTERNAL TABLE author
-(
- id int,
- fname varchar(20),
- lname varchar(20)
-)
-STORED BY 'org.apache.hive.storage.jdbc.JdbcStorageHandler'
-TBLPROPERTIES (
- "hive.sql.database.type" = "MSSQL",
- "hive.sql.jdbc.driver" = "com.microsoft.sqlserver.jdbc.SQLServerDriver",
- "hive.sql.jdbc.url" = "jdbc:sqlserver://localhost:1433",
- "hive.sql.dbcp.username" = "sa",
- "hive.sql.dbcp.password" = "Its-a-s3cret",
- "hive.sql.table" = "author"
- )
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@author
-PREHOOK: query: SELECT * FROM author
-PREHOOK: type: QUERY
-PREHOOK: Input: default@author
-#### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM author
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@author
-#### A masked pattern was here ####
-1 Victor Hugo
-2 Alexandre Dumas
-PREHOOK: query: CREATE EXTERNAL TABLE book
-(
- id int,
- title varchar(100),
- author int
-)
- STORED BY 'org.apache.hive.storage.jdbc.JdbcStorageHandler'
- TBLPROPERTIES (
- "hive.sql.database.type" = "ORACLE",
- "hive.sql.jdbc.driver" = "oracle.jdbc.OracleDriver",
- "hive.sql.jdbc.url" = "jdbc:oracle:thin:@//localhost:1521/xe",
- "hive.sql.dbcp.username" = "SYS as SYSDBA",
- "hive.sql.dbcp.password" = "oracle",
- "hive.sql.table" = "BOOK"
- )
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@book
-POSTHOOK: query: CREATE EXTERNAL TABLE book
-(
- id int,
- title varchar(100),
- author int
-)
- STORED BY 'org.apache.hive.storage.jdbc.JdbcStorageHandler'
- TBLPROPERTIES (
- "hive.sql.database.type" = "ORACLE",
- "hive.sql.jdbc.driver" = "oracle.jdbc.OracleDriver",
- "hive.sql.jdbc.url" = "jdbc:oracle:thin:@//localhost:1521/xe",
- "hive.sql.dbcp.username" = "SYS as SYSDBA",
- "hive.sql.dbcp.password" = "oracle",
- "hive.sql.table" = "BOOK"
- )
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@book
-PREHOOK: query: SELECT * FROM book
-PREHOOK: type: QUERY
-PREHOOK: Input: default@book
-#### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM book
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@book
-#### A masked pattern was here ####
-1 Les Miserables 1
-2 The Count Of Monte Cristo 2
