You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by se...@apache.org on 2015/09/04 04:55:04 UTC
[15/28] hive git commit: HIVE-11536 follow up,
seems earlier commit had strange line endings
HIVE-11536 follow up, seems earlier commit had strange line endings
Project: http://git-wip-us.apache.org/repos/asf/hive/repo
Commit: http://git-wip-us.apache.org/repos/asf/hive/commit/c0690a69
Tree: http://git-wip-us.apache.org/repos/asf/hive/tree/c0690a69
Diff: http://git-wip-us.apache.org/repos/asf/hive/diff/c0690a69
Branch: refs/heads/llap
Commit: c0690a69dcd4976435f8b33084f9b9b3c0c16889
Parents: b22e54e
Author: Alan Gates <ga...@hortonworks.com>
Authored: Tue Sep 1 09:57:24 2015 -0700
Committer: Alan Gates <ga...@hortonworks.com>
Committed: Tue Sep 1 09:57:24 2015 -0700
----------------------------------------------------------------------
.../src/test/queries/db/rowtype_attribute.sql | 42 ++++----
hplsql/src/test/queries/db/type_attribute.sql | 14 +--
.../local/create_procedure_no_params.sql | 36 +++----
.../test/queries/offline/create_table_ora.sql | 104 +++++++++----------
4 files changed, 98 insertions(+), 98 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/hive/blob/c0690a69/hplsql/src/test/queries/db/rowtype_attribute.sql
----------------------------------------------------------------------
diff --git a/hplsql/src/test/queries/db/rowtype_attribute.sql b/hplsql/src/test/queries/db/rowtype_attribute.sql
index 6a84b57..2fc65ce 100644
--- a/hplsql/src/test/queries/db/rowtype_attribute.sql
+++ b/hplsql/src/test/queries/db/rowtype_attribute.sql
@@ -1,22 +1,22 @@
-DECLARE
- v1 default.src%ROWTYPE;
- v2 src %ROWTYPE;
- v3 src % ROWTYPE;
- CURSOR c1 IS SELECT 'A' AS key, 'B' AS value FROM src LIMIT 1;
-BEGIN
- SELECT 'A' AS key, 'B' AS value INTO v1 FROM src LIMIT 1;
- PRINT v1.key || v1.value;
-
- OPEN c1;
- FETCH c1 INTO v2;
- PRINT v2.key || v2.value;
- CLOSE c1;
-
- FOR rec IN (SELECT 'A' AS key, 'B' AS value FROM src LIMIT 1)
- LOOP
- PRINT rec.key || rec.value;
- END LOOP;
-
- EXECUTE IMMEDIATE 'SELECT ''A'' AS key, ''B'' AS value FROM src LIMIT 1' INTO v3;
- PRINT v3.key || v3.value;
+DECLARE
+ v1 default.src%ROWTYPE;
+ v2 src %ROWTYPE;
+ v3 src % ROWTYPE;
+ CURSOR c1 IS SELECT 'A' AS key, 'B' AS value FROM src LIMIT 1;
+BEGIN
+ SELECT 'A' AS key, 'B' AS value INTO v1 FROM src LIMIT 1;
+ PRINT v1.key || v1.value;
+
+ OPEN c1;
+ FETCH c1 INTO v2;
+ PRINT v2.key || v2.value;
+ CLOSE c1;
+
+ FOR rec IN (SELECT 'A' AS key, 'B' AS value FROM src LIMIT 1)
+ LOOP
+ PRINT rec.key || rec.value;
+ END LOOP;
+
+ EXECUTE IMMEDIATE 'SELECT ''A'' AS key, ''B'' AS value FROM src LIMIT 1' INTO v3;
+ PRINT v3.key || v3.value;
END
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/hive/blob/c0690a69/hplsql/src/test/queries/db/type_attribute.sql
----------------------------------------------------------------------
diff --git a/hplsql/src/test/queries/db/type_attribute.sql b/hplsql/src/test/queries/db/type_attribute.sql
index 2d93bfd..059c291 100644
--- a/hplsql/src/test/queries/db/type_attribute.sql
+++ b/hplsql/src/test/queries/db/type_attribute.sql
@@ -1,8 +1,8 @@
-DECLARE
- v1 default.src.key%TYPE;
- v2 src.Key %TYPE;
- v3 src.key3 % TYPE;
-BEGIN
- SELECT 'A', 'B', 1 INTO v1, v2, v3 FROM src LIMIT 1;
- PRINT v1 || v2 || v3;
+DECLARE
+ v1 default.src.key%TYPE;
+ v2 src.Key %TYPE;
+ v3 src.key3 % TYPE;
+BEGIN
+ SELECT 'A', 'B', 1 INTO v1, v2, v3 FROM src LIMIT 1;
+ PRINT v1 || v2 || v3;
END
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/hive/blob/c0690a69/hplsql/src/test/queries/local/create_procedure_no_params.sql
----------------------------------------------------------------------
diff --git a/hplsql/src/test/queries/local/create_procedure_no_params.sql b/hplsql/src/test/queries/local/create_procedure_no_params.sql
index 535ba98..c4c2992 100644
--- a/hplsql/src/test/queries/local/create_procedure_no_params.sql
+++ b/hplsql/src/test/queries/local/create_procedure_no_params.sql
@@ -1,19 +1,19 @@
-create procedure sp1
-begin
- print 'a';
-end;
-
-create procedure sp2()
-begin
- print 'b';
-end;
-
-call sp1;
-call sp1();
-sp1;
-sp1();
-
-call sp2;
-call sp2();
-sp2;
+create procedure sp1
+begin
+ print 'a';
+end;
+
+create procedure sp2()
+begin
+ print 'b';
+end;
+
+call sp1;
+call sp1();
+sp1;
+sp1();
+
+call sp2;
+call sp2();
+sp2;
sp2();
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/hive/blob/c0690a69/hplsql/src/test/queries/offline/create_table_ora.sql
----------------------------------------------------------------------
diff --git a/hplsql/src/test/queries/offline/create_table_ora.sql b/hplsql/src/test/queries/offline/create_table_ora.sql
index bb1d9c7..40a543a 100644
--- a/hplsql/src/test/queries/offline/create_table_ora.sql
+++ b/hplsql/src/test/queries/offline/create_table_ora.sql
@@ -1,53 +1,53 @@
-CREATE TABLE ora_t1 (
- n1 NUMBER(3,0),
- v1 VARCHAR2(10)
-);
-
-CREATE TABLE "USER"."EMP"
- ( "EMPNO" NUMBER(4,0),
- "ENAME" VARCHAR2(10 BYTE),
- "JOB" VARCHAR2(9 BYTE),
- "MGR" NUMBER(4,0),
- "HIREDATE" DATE,
- "SAL" NUMBER(7,2),
- "COMM" NUMBER(7,2),
- "DEPTNO" NUMBER(2,0)
- ) SEGMENT CREATION IMMEDIATE
- PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- TABLESPACE "USERS" ;
-
-CREATE TABLE language (
- id NUMBER(7) NOT NULL PRIMARY KEY,
- cd CHAR(2) NOT NULL,
- description VARCHAR2(50)
-);
-CREATE TABLE author (
- id NUMBER(7) NOT NULL PRIMARY KEY,
- first_name VARCHAR2(50),
- last_name VARCHAR2(50) NOT NULL,
- date_of_birth DATE,
- year_of_birth NUMBER(7),
- distinguished NUMBER(1)
-);
-CREATE TABLE book (
- id NUMBER(7) NOT NULL PRIMARY KEY,
- author_id NUMBER(7) NOT NULL,
- title VARCHAR2(400) NOT NULL,
- published_in NUMBER(7) NOT NULL,
- language_id NUMBER(7) NOT NULL,
- CONSTRAINT fk_book_author FOREIGN KEY (author_id) REFERENCES author(id),
- CONSTRAINT fk_book_language FOREIGN KEY (language_id) REFERENCES language(id)
-);
-CREATE TABLE book_store (
- name VARCHAR2(400) NOT NULL UNIQUE
-);
-CREATE TABLE book_to_book_store (
- name VARCHAR2(400) NOT NULL,
- book_id INTEGER NOT NULL,
- stock INTEGER,
- PRIMARY KEY(name, book_id),
- CONSTRAINT fk_b2bs_book_store FOREIGN KEY (name) REFERENCES book_store (name) ON DELETE CASCADE,
- CONSTRAINT fk_b2bs_book FOREIGN KEY (book_id) REFERENCES book (id) ON DELETE CASCADE
+CREATE TABLE ora_t1 (
+ n1 NUMBER(3,0),
+ v1 VARCHAR2(10)
+);
+
+CREATE TABLE "USER"."EMP"
+ ( "EMPNO" NUMBER(4,0),
+ "ENAME" VARCHAR2(10 BYTE),
+ "JOB" VARCHAR2(9 BYTE),
+ "MGR" NUMBER(4,0),
+ "HIREDATE" DATE,
+ "SAL" NUMBER(7,2),
+ "COMM" NUMBER(7,2),
+ "DEPTNO" NUMBER(2,0)
+ ) SEGMENT CREATION IMMEDIATE
+ PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
+ STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
+ PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
+ TABLESPACE "USERS" ;
+
+CREATE TABLE language (
+ id NUMBER(7) NOT NULL PRIMARY KEY,
+ cd CHAR(2) NOT NULL,
+ description VARCHAR2(50)
+);
+CREATE TABLE author (
+ id NUMBER(7) NOT NULL PRIMARY KEY,
+ first_name VARCHAR2(50),
+ last_name VARCHAR2(50) NOT NULL,
+ date_of_birth DATE,
+ year_of_birth NUMBER(7),
+ distinguished NUMBER(1)
+);
+CREATE TABLE book (
+ id NUMBER(7) NOT NULL PRIMARY KEY,
+ author_id NUMBER(7) NOT NULL,
+ title VARCHAR2(400) NOT NULL,
+ published_in NUMBER(7) NOT NULL,
+ language_id NUMBER(7) NOT NULL,
+ CONSTRAINT fk_book_author FOREIGN KEY (author_id) REFERENCES author(id),
+ CONSTRAINT fk_book_language FOREIGN KEY (language_id) REFERENCES language(id)
+);
+CREATE TABLE book_store (
+ name VARCHAR2(400) NOT NULL UNIQUE
+);
+CREATE TABLE book_to_book_store (
+ name VARCHAR2(400) NOT NULL,
+ book_id INTEGER NOT NULL,
+ stock INTEGER,
+ PRIMARY KEY(name, book_id),
+ CONSTRAINT fk_b2bs_book_store FOREIGN KEY (name) REFERENCES book_store (name) ON DELETE CASCADE,
+ CONSTRAINT fk_b2bs_book FOREIGN KEY (book_id) REFERENCES book (id) ON DELETE CASCADE
);
\ No newline at end of file