[GitHub] incubator-trafodion pull request #1301: new COMMENT-ON SQL statement: resolv...

[EEDY]

GitHub user EEDY opened a pull request:

https://github.com/apache/incubator-trafodion/pull/1301

new COMMENT-ON SQL statement: resolve merge conflict

1. resolve enum type conflict while merging to esgyn

Compiled and test.

You can merge this pull request into a Git repository by running:

$ git pull https://github.com/EEDY/incubator-trafodion master

Alternatively you can review and apply these changes as the patch at:

https://github.com/apache/incubator-trafodion/pull/1301.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

This closes #1301


commit ad6d7350cef85de36e4af0cf035f1e557054aec4
Author: eedy 
Date:   2017-11-16T04:04:33Z

new COMMENT-ON SQL statement: resolve merge conflict

1. resolve enum type conflict while merging to esgyn




---

[GitHub] incubator-trafodion pull request #1300: [TRAFODION-2807] We need support ODB...

[SuJinpei]

GitHub user SuJinpei opened a pull request:

https://github.com/apache/incubator-trafodion/pull/1300

[TRAFODION-2807] We need support ODBC windows 32 bit driver build.

add a bat script to build 32-bit driver.
add iss script to generate 32-bit driver installer.
add 32-bit driver build steps to README

You can merge this pull request into a Git repository by running:

$ git pull https://github.com/SuJinpei/incubator-trafodion trafodion-2807

Alternatively you can review and apply these changes as the patch at:

https://github.com/apache/incubator-trafodion/pull/1300.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

This closes #1300


commit cba9de3def0abfa07467ec93f2befa6e68f9ef54
Author: SuJinpei <873118...@qq.com>
Date:   2017-11-15T10:48:00Z

support windows 32-bit driver build

commit 7c02ee613020a064e708a93a5f231b8380a9245c
Author: SuJinpei <873118...@qq.com>
Date:   2017-11-16T03:44:20Z

change install script for windows ODBC 32-bit driver




---

[GitHub] incubator-trafodion pull request #1295: [TRAFODION-2794] Add *DIVISION BY (C...

[asfgit]

Github user asfgit closed the pull request at:

https://github.com/apache/incubator-trafodion/pull/1295


---

[GitHub] incubator-trafodion pull request #1288: New COMMENT-ON SQL statement

[asfgit]

Github user asfgit closed the pull request at:

https://github.com/apache/incubator-trafodion/pull/1288


---

[GitHub] incubator-trafodion pull request #1295: [TRAFODION-2794] Add *DIVISION BY (C...

[liuyu000]

Github user liuyu000 commented on a diff in the pull request:


https://github.com/apache/incubator-trafodion/pull/1295#discussion_r151065267
  
--- Diff: docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc ---
@@ -3308,6 +3343,43 @@ SELECT * FROM T WHERE b = 'A';
 SELECT * FROM T WHERE b = 'A' (not casespecific);
 ```
 
+* This is the 1^st^ example of DIVISION BY usage.
++
+```
+CREATE TABLE call_home_data
+(id LARGEINT NOT NULL,
+ts TIMESTAMP(6) NOT NULL,
+device_status VARCHAR(200),
+PRIMARY KEY (id, ts))
+SALT USING 16 PARTITIONS ON (id)
+DIVISION BY (date_trunc('day', ts));
+```
+
+* This is the 2^nd^ example of DIVISION BY usage.
--- End diff --

Thanks Dave.
I've corrected. :)


---

[GitHub] incubator-trafodion pull request #1295: [TRAFODION-2794] Add *DIVISION BY (C...

[liuyu000]

Github user liuyu000 commented on a diff in the pull request:


https://github.com/apache/incubator-trafodion/pull/1295#discussion_r151065344
  
--- Diff: docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc ---
@@ -3308,6 +3343,43 @@ SELECT * FROM T WHERE b = 'A';
 SELECT * FROM T WHERE b = 'A' (not casespecific);
 ```
 
+* This is the 1^st^ example of DIVISION BY usage.
++
+```
+CREATE TABLE call_home_data
+(id LARGEINT NOT NULL,
+ts TIMESTAMP(6) NOT NULL,
+device_status VARCHAR(200),
+PRIMARY KEY (id, ts))
+SALT USING 16 PARTITIONS ON (id)
+DIVISION BY (date_trunc('day', ts));
+```
+
+* This is the 2^nd^ example of DIVISION BY usage.
++
+```
+CREATE TABLE sales1
+(store_id INT NOT NULL,
+item_id  INT NOT NULL,
+sale_date DATE DEFAULT DATE '2000-01-01' NOT NULL,
+sale_amt NUMERIC(10,2),
+PRIMARY KEY (store_id, item_id, sale_date))
+DIVISION BY (DATEDIFF(YEAR, '2017-11-02', sale_date));
+```
+
+* This is the 3^rd^ example of DIVISION BY usage.
--- End diff --

Thanks for your details.
I've corrected. :)


---

[GitHub] incubator-trafodion pull request #1295: [TRAFODION-2794] Add *DIVISION BY (C...

[liuyu000]

Github user liuyu000 commented on a diff in the pull request:


https://github.com/apache/incubator-trafodion/pull/1295#discussion_r151065104
  
--- Diff: docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc ---
@@ -2816,6 +2817,38 @@ Considerations for LOAD IF EXISTS and NO LOAD 
options of CREATE TABLE AS>>.
 +
 specifies a select query which is used to populate the created table. A 
select query can be any SQL select statement.
 
+* `_division-expr-list_`
++
+is a list of expressions that can only refer to primary key or STORE BY 
columns.
+
++
+The followings are allowed expressions in the DIVISON BY clause, they are 
monotonically increasing expressions:
--- End diff --

Thanks Dave.
I've corrected. :)


---

[GitHub] incubator-trafodion pull request #1295: [TRAFODION-2794] Add *DIVISION BY (C...

[liuyu000]

Github user liuyu000 commented on a diff in the pull request:


https://github.com/apache/incubator-trafodion/pull/1295#discussion_r151065065
  
--- Diff: 
docs/sql_reference/src/asciidoc/_chapters/sql_functions_and_expressions.adoc ---
@@ -2573,7 +2573,7 @@ DATE_PART('year', date'12/05/2006')
 DATE_PART('day', TIMESTAMP '2006-12-31 11:59:59.99')
 ```
 
-* This function returns the value 201 07.
+* This function returns the value 2011 07.
--- End diff --

Thanks for your reminding, yes it returns 201107. 
I've corrected. :)


---

[GitHub] incubator-trafodion pull request #1295: [TRAFODION-2794] Add *DIVISION BY (C...

[liuyu000]

Github user liuyu000 commented on a diff in the pull request:


https://github.com/apache/incubator-trafodion/pull/1295#discussion_r151065116
  
--- Diff: docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc ---
@@ -3308,6 +3343,43 @@ SELECT * FROM T WHERE b = 'A';
 SELECT * FROM T WHERE b = 'A' (not casespecific);
 ```
 
+* This is the 1^st^ example of DIVISION BY usage.
--- End diff --

Thanks Dave.
I've corrected. :)


---