[jira] [Commented] (HIVE-21095) 'Show create table' should not display a time zone for timestamp with local time zone
[ https://issues.apache.org/jira/browse/HIVE-21095?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16743894#comment-16743894 ] Marta Kuczora commented on HIVE-21095: -- Pushed to master. Thanks again [~klcopp] for the patch. > 'Show create table' should not display a time zone for timestamp with local > time zone > - > > Key: HIVE-21095 > URL: https://issues.apache.org/jira/browse/HIVE-21095 > Project: Hive > Issue Type: Improvement >Reporter: Karen Coppage >Assignee: Karen Coppage >Priority: Major > Attachments: HIVE-21095.1.patch, HIVE-21095.2.patch, > HIVE-21095.2.patch, HIVE-21095.2.patch, HIVE-21095.3.patch, HIVE-21095.4.patch > > > SHOW CREATE TABLE shows the time zone that the table was created in (if it > contains a TIMESTAMPTZ column). This is also misleading, since it has nothing > to do with the actual data or server or user time zone. > e.g. > {code:java} > hive> set time zone America/Los_Angeles; > hive> create table text_local (ts timestamp with local time zone) stored as > textfile; > hive> show create table text_local; > CREATE TABLE `text_local`( > `ts` timestamp with local time zone('America/Los_Angeles')) > {code} > should be: > {code:java} > hive> show create table text_local; > CREATE TABLE `text_local`( > `ts` timestamp with local time zone) > {code} > This was discussed in the community doc [Consistent timestamp types in Hadoop > SQL > engines|https://docs.google.com/document/d/1gNRww9mZJcHvUDCXklzjFEQGpefsuR_akCDfWsdE35Q/edit?usp=sharing] -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-21095) 'Show create table' should not display a time zone for timestamp with local time zone
[ https://issues.apache.org/jira/browse/HIVE-21095?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16743780#comment-16743780 ] Karen Coppage commented on HIVE-21095: -- Thanks for the reviews, [~kuczoram] and [~jcamachorodriguez] > 'Show create table' should not display a time zone for timestamp with local > time zone > - > > Key: HIVE-21095 > URL: https://issues.apache.org/jira/browse/HIVE-21095 > Project: Hive > Issue Type: Improvement >Reporter: Karen Coppage >Assignee: Karen Coppage >Priority: Major > Attachments: HIVE-21095.1.patch, HIVE-21095.2.patch, > HIVE-21095.2.patch, HIVE-21095.2.patch, HIVE-21095.3.patch, HIVE-21095.4.patch > > > SHOW CREATE TABLE shows the time zone that the table was created in (if it > contains a TIMESTAMPTZ column). This is also misleading, since it has nothing > to do with the actual data or server or user time zone. > e.g. > {code:java} > hive> set time zone America/Los_Angeles; > hive> create table text_local (ts timestamp with local time zone) stored as > textfile; > hive> show create table text_local; > CREATE TABLE `text_local`( > `ts` timestamp with local time zone('America/Los_Angeles')) > {code} > should be: > {code:java} > hive> show create table text_local; > CREATE TABLE `text_local`( > `ts` timestamp with local time zone) > {code} > This was discussed in the community doc [Consistent timestamp types in Hadoop > SQL > engines|https://docs.google.com/document/d/1gNRww9mZJcHvUDCXklzjFEQGpefsuR_akCDfWsdE35Q/edit?usp=sharing] -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-21095) 'Show create table' should not display a time zone for timestamp with local time zone
[ https://issues.apache.org/jira/browse/HIVE-21095?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16743223#comment-16743223 ] Jesus Camacho Rodriguez commented on HIVE-21095: +1, thanks [~klcopp] > 'Show create table' should not display a time zone for timestamp with local > time zone > - > > Key: HIVE-21095 > URL: https://issues.apache.org/jira/browse/HIVE-21095 > Project: Hive > Issue Type: Improvement >Reporter: Karen Coppage >Assignee: Karen Coppage >Priority: Major > Attachments: HIVE-21095.1.patch, HIVE-21095.2.patch, > HIVE-21095.2.patch, HIVE-21095.2.patch, HIVE-21095.3.patch, HIVE-21095.4.patch > > > SHOW CREATE TABLE shows the time zone that the table was created in (if it > contains a TIMESTAMPTZ column). This is also misleading, since it has nothing > to do with the actual data or server or user time zone. > e.g. > {code:java} > hive> set time zone America/Los_Angeles; > hive> create table text_local (ts timestamp with local time zone) stored as > textfile; > hive> show create table text_local; > CREATE TABLE `text_local`( > `ts` timestamp with local time zone('America/Los_Angeles')) > {code} > should be: > {code:java} > hive> show create table text_local; > CREATE TABLE `text_local`( > `ts` timestamp with local time zone) > {code} > This was discussed in the community doc [Consistent timestamp types in Hadoop > SQL > engines|https://docs.google.com/document/d/1gNRww9mZJcHvUDCXklzjFEQGpefsuR_akCDfWsdE35Q/edit?usp=sharing] -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-21095) 'Show create table' should not display a time zone for timestamp with local time zone
[ https://issues.apache.org/jira/browse/HIVE-21095?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16743183#comment-16743183 ] Karen Coppage commented on HIVE-21095: -- Hi [~jcamachorodriguez], this issue was touched on in your discussion with Zoltan Ivanfi, since this doesn't have to do with UTC-normalization :) would you be willing to review this patch? > 'Show create table' should not display a time zone for timestamp with local > time zone > - > > Key: HIVE-21095 > URL: https://issues.apache.org/jira/browse/HIVE-21095 > Project: Hive > Issue Type: Improvement >Reporter: Karen Coppage >Assignee: Karen Coppage >Priority: Major > Attachments: HIVE-21095.1.patch, HIVE-21095.2.patch, > HIVE-21095.2.patch, HIVE-21095.2.patch, HIVE-21095.3.patch, HIVE-21095.4.patch > > > SHOW CREATE TABLE shows the time zone that the table was created in (if it > contains a TIMESTAMPTZ column). This is also misleading, since it has nothing > to do with the actual data or server or user time zone. > e.g. > {code:java} > hive> set time zone America/Los_Angeles; > hive> create table text_local (ts timestamp with local time zone) stored as > textfile; > hive> show create table text_local; > CREATE TABLE `text_local`( > `ts` timestamp with local time zone('America/Los_Angeles')) > {code} > should be: > {code:java} > hive> show create table text_local; > CREATE TABLE `text_local`( > `ts` timestamp with local time zone) > {code} > This was discussed in the community doc [Consistent timestamp types in Hadoop > SQL > engines|https://docs.google.com/document/d/1gNRww9mZJcHvUDCXklzjFEQGpefsuR_akCDfWsdE35Q/edit?usp=sharing] -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-21095) 'Show create table' should not display a time zone for timestamp with local time zone
[ https://issues.apache.org/jira/browse/HIVE-21095?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16740569#comment-16740569 ] Hive QA commented on HIVE-21095: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12954606/HIVE-21095.4.patch {color:red}ERROR:{color} -1 due to no test(s) being added or modified. {color:green}SUCCESS:{color} +1 due to 15712 tests passed Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/15594/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/15594/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-15594/ Messages: {noformat} Executing org.apache.hive.ptest.execution.TestCheckPhase Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.YetusPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase {noformat} This message is automatically generated. ATTACHMENT ID: 12954606 - PreCommit-HIVE-Build > 'Show create table' should not display a time zone for timestamp with local > time zone > - > > Key: HIVE-21095 > URL: https://issues.apache.org/jira/browse/HIVE-21095 > Project: Hive > Issue Type: Improvement >Reporter: Karen Coppage >Assignee: Karen Coppage >Priority: Major > Attachments: HIVE-21095.1.patch, HIVE-21095.2.patch, > HIVE-21095.2.patch, HIVE-21095.2.patch, HIVE-21095.3.patch, HIVE-21095.4.patch > > > SHOW CREATE TABLE shows the time zone that the table was created in (if it > contains a TIMESTAMPTZ column). This is also misleading, since it has nothing > to do with the actual data or server or user time zone. > e.g. > {code:java} > hive> set time zone America/Los_Angeles; > hive> create table text_local (ts timestamp with local time zone) stored as > textfile; > hive> show create table text_local; > CREATE TABLE `text_local`( > `ts` timestamp with local time zone('America/Los_Angeles')) > {code} > should be: > {code:java} > hive> show create table text_local; > CREATE TABLE `text_local`( > `ts` timestamp with local time zone) > {code} > This was discussed in the community doc [Consistent timestamp types in Hadoop > SQL > engines|https://docs.google.com/document/d/1gNRww9mZJcHvUDCXklzjFEQGpefsuR_akCDfWsdE35Q/edit?usp=sharing] -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-21095) 'Show create table' should not display a time zone for timestamp with local time zone
[ https://issues.apache.org/jira/browse/HIVE-21095?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16740548#comment-16740548 ] Hive QA commented on HIVE-21095: | (/) *{color:green}+1 overall{color}* | \\ \\ || Vote || Subsystem || Runtime || Comment || || || || || {color:brown} Prechecks {color} || | {color:green}+1{color} | {color:green} @author {color} | {color:green} 0m 0s{color} | {color:green} The patch does not contain any @author tags. {color} | || || || || {color:brown} master Compile Tests {color} || | {color:blue}0{color} | {color:blue} mvndep {color} | {color:blue} 1m 32s{color} | {color:blue} Maven dependency ordering for branch {color} | | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 6m 30s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 14s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 0m 51s{color} | {color:green} master passed {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 0m 35s{color} | {color:blue} serde in master has 198 extant Findbugs warnings. {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 3m 39s{color} | {color:blue} ql in master has 2309 extant Findbugs warnings. {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 1m 8s{color} | {color:green} master passed {color} | || || || || {color:brown} Patch Compile Tests {color} || | {color:blue}0{color} | {color:blue} mvndep {color} | {color:blue} 0m 26s{color} | {color:blue} Maven dependency ordering for patch {color} | | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 1m 42s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 15s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javac {color} | {color:green} 1m 15s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 0m 50s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} whitespace {color} | {color:green} 0m 0s{color} | {color:green} The patch has no whitespace issues. {color} | | {color:green}+1{color} | {color:green} findbugs {color} | {color:green} 4m 29s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 1m 8s{color} | {color:green} the patch passed {color} | || || || || {color:brown} Other Tests {color} || | {color:green}+1{color} | {color:green} asflicense {color} | {color:green} 0m 13s{color} | {color:green} The patch does not generate ASF License warnings. {color} | | {color:black}{color} | {color:black} {color} | {color:black} 26m 12s{color} | {color:black} {color} | \\ \\ || Subsystem || Report/Notes || | Optional Tests | asflicense javac javadoc findbugs checkstyle compile | | uname | Linux hiveptest-server-upstream 3.16.0-4-amd64 #1 SMP Debian 3.16.36-1+deb8u1 (2016-09-03) x86_64 GNU/Linux | | Build tool | maven | | Personality | /data/hiveptest/working/yetus_PreCommit-HIVE-Build-15594/dev-support/hive-personality.sh | | git revision | master / f713140 | | Default Java | 1.8.0_111 | | findbugs | v3.0.0 | | modules | C: serde ql U: . | | Console output | http://104.198.109.242/logs//PreCommit-HIVE-Build-15594/yetus.txt | | Powered by | Apache Yetushttp://yetus.apache.org | This message was automatically generated. > 'Show create table' should not display a time zone for timestamp with local > time zone > - > > Key: HIVE-21095 > URL: https://issues.apache.org/jira/browse/HIVE-21095 > Project: Hive > Issue Type: Improvement >Reporter: Karen Coppage >Assignee: Karen Coppage >Priority: Major > Attachments: HIVE-21095.1.patch, HIVE-21095.2.patch, > HIVE-21095.2.patch, HIVE-21095.2.patch, HIVE-21095.3.patch, HIVE-21095.4.patch > > > SHOW CREATE TABLE shows the time zone that the table was created in (if it > contains a TIMESTAMPTZ column). This is also misleading, since it has nothing > to do with the actual data or server or user time zone. > e.g. > {code:java} > hive> set time zone America/Los_Angeles; > hive> create table text_local (ts timestamp with local time zone) stored as > textfile; > hive> show create table text_local; > CREATE TABLE `text_local`( > `ts` timestamp with local time zone('America/Los_Angeles')) > {code} > should be: > {code:java} > hive> show create table text_local; > CREATE TABLE `text_local`( > `ts` timestamp with local time zone) > {code} > This
[jira] [Commented] (HIVE-21095) 'Show create table' should not display a time zone for timestamp with local time zone
[ https://issues.apache.org/jira/browse/HIVE-21095?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16740498#comment-16740498 ] Hive QA commented on HIVE-21095: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12954601/HIVE-21095.3.patch {color:red}ERROR:{color} -1 due to build exiting with an error Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/15593/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/15593/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-15593/ Messages: {noformat} Executing org.apache.hive.ptest.execution.TestCheckPhase Executing org.apache.hive.ptest.execution.PrepPhase Tests exited with: NonZeroExitCodeException Command 'bash /data/hiveptest/working/scratch/source-prep.sh' failed with exit status 1 and output '+ date '+%Y-%m-%d %T.%3N' 2019-01-11 15:40:58.019 + [[ -n /usr/lib/jvm/java-8-openjdk-amd64 ]] + export JAVA_HOME=/usr/lib/jvm/java-8-openjdk-amd64 + JAVA_HOME=/usr/lib/jvm/java-8-openjdk-amd64 + export PATH=/usr/lib/jvm/java-8-openjdk-amd64/bin/:/usr/local/bin:/usr/bin:/bin:/usr/local/games:/usr/games + PATH=/usr/lib/jvm/java-8-openjdk-amd64/bin/:/usr/local/bin:/usr/bin:/bin:/usr/local/games:/usr/games + export 'ANT_OPTS=-Xmx1g -XX:MaxPermSize=256m ' + ANT_OPTS='-Xmx1g -XX:MaxPermSize=256m ' + export 'MAVEN_OPTS=-Xmx1g ' + MAVEN_OPTS='-Xmx1g ' + cd /data/hiveptest/working/ + tee /data/hiveptest/logs/PreCommit-HIVE-Build-15593/source-prep.txt + [[ false == \t\r\u\e ]] + mkdir -p maven ivy + [[ git = \s\v\n ]] + [[ git = \g\i\t ]] + [[ -z master ]] + [[ -d apache-github-source-source ]] + [[ ! -d apache-github-source-source/.git ]] + [[ ! -d apache-github-source-source ]] + date '+%Y-%m-%d %T.%3N' 2019-01-11 15:40:58.022 + cd apache-github-source-source + git fetch origin + git reset --hard HEAD HEAD is now at f713140 HIVE-21036 extend OpenTxnRequest with transaction type (Igor Kryvenko via Eugene Koifman) + git clean -f -d Removing standalone-metastore/metastore-server/src/gen/ + git checkout master Already on 'master' Your branch is up-to-date with 'origin/master'. + git reset --hard origin/master HEAD is now at f713140 HIVE-21036 extend OpenTxnRequest with transaction type (Igor Kryvenko via Eugene Koifman) + git merge --ff-only origin/master Already up-to-date. + date '+%Y-%m-%d %T.%3N' 2019-01-11 15:40:58.998 + rm -rf ../yetus_PreCommit-HIVE-Build-15593 + mkdir ../yetus_PreCommit-HIVE-Build-15593 + git gc + cp -R . ../yetus_PreCommit-HIVE-Build-15593 + mkdir /data/hiveptest/logs/PreCommit-HIVE-Build-15593/yetus + patchCommandPath=/data/hiveptest/working/scratch/smart-apply-patch.sh + patchFilePath=/data/hiveptest/working/scratch/build.patch + [[ -f /data/hiveptest/working/scratch/build.patch ]] + chmod +x /data/hiveptest/working/scratch/smart-apply-patch.sh + /data/hiveptest/working/scratch/smart-apply-patch.sh /data/hiveptest/working/scratch/build.patch Going to apply patch with: git apply -p0 /data/hiveptest/working/scratch/build.patch:30: trailing whitespace. tz timestamp with local time zone /data/hiveptest/working/scratch/build.patch:39: trailing whitespace. tz1 timestamp with local time zone warning: 2 lines add whitespace errors. + [[ maven == \m\a\v\e\n ]] + rm -rf /data/hiveptest/working/maven/org/apache/hive + mvn -B clean install -DskipTests -T 4 -q -Dmaven.repo.local=/data/hiveptest/working/maven protoc-jar: executing: [/tmp/protoc670848821385867120.exe, --version] libprotoc 2.5.0 protoc-jar: executing: [/tmp/protoc670848821385867120.exe, -I/data/hiveptest/working/apache-github-source-source/standalone-metastore/metastore-common/src/main/protobuf/org/apache/hadoop/hive/metastore, --java_out=/data/hiveptest/working/apache-github-source-source/standalone-metastore/metastore-common/target/generated-sources, /data/hiveptest/working/apache-github-source-source/standalone-metastore/metastore-common/src/main/protobuf/org/apache/hadoop/hive/metastore/metastore.proto] ANTLR Parser Generator Version 3.5.2 protoc-jar: executing: [/tmp/protoc4138762858751902920.exe, --version] libprotoc 2.5.0 ANTLR Parser Generator Version 3.5.2 Output file /data/hiveptest/working/apache-github-source-source/standalone-metastore/metastore-server/target/generated-sources/org/apache/hadoop/hive/metastore/parser/FilterParser.java does not exist: must build /data/hiveptest/working/apache-github-source-source/standalone-metastore/metastore-server/src/main/java/org/apache/hadoop/hive/metastore/parser/Filter.g org/apache/hadoop/hive/metastore/parser/Filter.g log4j:WARN No appenders could be found for logger (DataNucleus.Persistence). log4j:WARN Please initialize the log4j system properly. DataNucleus Enhancer (version 4.1.17) for API "JDO" DataNucleus Enhancer completed with success for 41 classes. ANTLR Parser
[jira] [Commented] (HIVE-21095) 'Show create table' should not display a time zone for timestamp with local time zone
[ https://issues.apache.org/jira/browse/HIVE-21095?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16740411#comment-16740411 ] Marta Kuczora commented on HIVE-21095: -- +1 Thanks a lot [~klcopp] for the patch. > 'Show create table' should not display a time zone for timestamp with local > time zone > - > > Key: HIVE-21095 > URL: https://issues.apache.org/jira/browse/HIVE-21095 > Project: Hive > Issue Type: Improvement >Reporter: Karen Coppage >Assignee: Karen Coppage >Priority: Major > Attachments: HIVE-21095.1.patch, HIVE-21095.2.patch, > HIVE-21095.2.patch, HIVE-21095.2.patch > > > SHOW CREATE TABLE shows the time zone that the table was created in (if it > contains a TIMESTAMPTZ column). This is also misleading, since it has nothing > to do with the actual data or server or user time zone. > e.g. > {code:java} > hive> set time zone America/Los_Angeles; > hive> create table text_local (ts timestamp with local time zone) stored as > textfile; > hive> show create table text_local; > CREATE TABLE `text_local`( > `ts` timestamp with local time zone('America/Los_Angeles')) > {code} > should be: > {code:java} > hive> show create table text_local; > CREATE TABLE `text_local`( > `ts` timestamp with local time zone) > {code} > This was discussed in the community doc [Consistent timestamp types in Hadoop > SQL > engines|https://docs.google.com/document/d/1gNRww9mZJcHvUDCXklzjFEQGpefsuR_akCDfWsdE35Q/edit?usp=sharing] -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-21095) 'Show create table' should not display a time zone for timestamp with local time zone
[ https://issues.apache.org/jira/browse/HIVE-21095?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16739727#comment-16739727 ] Hive QA commented on HIVE-21095: | (/) *{color:green}+1 overall{color}* | \\ \\ || Vote || Subsystem || Runtime || Comment || || || || || {color:brown} Prechecks {color} || | {color:green}+1{color} | {color:green} @author {color} | {color:green} 0m 0s{color} | {color:green} The patch does not contain any @author tags. {color} | || || || || {color:brown} master Compile Tests {color} || | {color:blue}0{color} | {color:blue} mvndep {color} | {color:blue} 1m 35s{color} | {color:blue} Maven dependency ordering for branch {color} | | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 6m 44s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 19s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 0m 48s{color} | {color:green} master passed {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 0m 39s{color} | {color:blue} serde in master has 198 extant Findbugs warnings. {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 3m 52s{color} | {color:blue} ql in master has 2309 extant Findbugs warnings. {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 1m 12s{color} | {color:green} master passed {color} | || || || || {color:brown} Patch Compile Tests {color} || | {color:blue}0{color} | {color:blue} mvndep {color} | {color:blue} 0m 27s{color} | {color:blue} Maven dependency ordering for patch {color} | | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 1m 40s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 21s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javac {color} | {color:green} 1m 21s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 0m 48s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} whitespace {color} | {color:green} 0m 0s{color} | {color:green} The patch has no whitespace issues. {color} | | {color:green}+1{color} | {color:green} findbugs {color} | {color:green} 4m 46s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 1m 9s{color} | {color:green} the patch passed {color} | || || || || {color:brown} Other Tests {color} || | {color:green}+1{color} | {color:green} asflicense {color} | {color:green} 0m 13s{color} | {color:green} The patch does not generate ASF License warnings. {color} | | {color:black}{color} | {color:black} {color} | {color:black} 27m 15s{color} | {color:black} {color} | \\ \\ || Subsystem || Report/Notes || | Optional Tests | asflicense javac javadoc findbugs checkstyle compile | | uname | Linux hiveptest-server-upstream 3.16.0-4-amd64 #1 SMP Debian 3.16.36-1+deb8u1 (2016-09-03) x86_64 GNU/Linux | | Build tool | maven | | Personality | /data/hiveptest/working/yetus_PreCommit-HIVE-Build-15579/dev-support/hive-personality.sh | | git revision | master / dcc8950 | | Default Java | 1.8.0_111 | | findbugs | v3.0.0 | | modules | C: serde ql U: . | | Console output | http://104.198.109.242/logs//PreCommit-HIVE-Build-15579/yetus.txt | | Powered by | Apache Yetushttp://yetus.apache.org | This message was automatically generated. > 'Show create table' should not display a time zone for timestamp with local > time zone > - > > Key: HIVE-21095 > URL: https://issues.apache.org/jira/browse/HIVE-21095 > Project: Hive > Issue Type: Improvement >Reporter: Karen Coppage >Assignee: Karen Coppage >Priority: Major > Attachments: HIVE-21095.1.patch, HIVE-21095.2.patch, > HIVE-21095.2.patch, HIVE-21095.2.patch > > > SHOW CREATE TABLE shows the time zone that the table was created in (if it > contains a TIMESTAMPTZ column). This is also misleading, since it has nothing > to do with the actual data or server or user time zone. > e.g. > {code:java} > hive> set time zone America/Los_Angeles; > hive> create table text_local (ts timestamp with local time zone) stored as > textfile; > hive> show create table text_local; > CREATE TABLE `text_local`( > `ts` timestamp with local time zone('America/Los_Angeles')) > {code} > should be: > {code:java} > hive> show create table text_local; > CREATE TABLE `text_local`( > `ts` timestamp with local time zone) > {code} > This was discussed in the community doc
[jira] [Commented] (HIVE-21095) 'Show create table' should not display a time zone for timestamp with local time zone
[ https://issues.apache.org/jira/browse/HIVE-21095?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16739759#comment-16739759 ] Hive QA commented on HIVE-21095: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12954432/HIVE-21095.2.patch {color:red}ERROR:{color} -1 due to no test(s) being added or modified. {color:red}ERROR:{color} -1 due to 3 failed/errored test(s), 15696 tests executed *Failed tests:* {noformat} TestAlterTableMetadata - did not produce a TEST-*.xml file (likely timed out) (batchId=251) TestReplAcidTablesWithJsonMessage - did not produce a TEST-*.xml file (likely timed out) (batchId=251) TestSemanticAnalyzerHookLoading - did not produce a TEST-*.xml file (likely timed out) (batchId=251) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/15579/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/15579/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-15579/ Messages: {noformat} Executing org.apache.hive.ptest.execution.TestCheckPhase Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.YetusPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase Tests exited with: TestsFailedException: 3 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12954432 - PreCommit-HIVE-Build > 'Show create table' should not display a time zone for timestamp with local > time zone > - > > Key: HIVE-21095 > URL: https://issues.apache.org/jira/browse/HIVE-21095 > Project: Hive > Issue Type: Improvement >Reporter: Karen Coppage >Assignee: Karen Coppage >Priority: Major > Attachments: HIVE-21095.1.patch, HIVE-21095.2.patch, > HIVE-21095.2.patch, HIVE-21095.2.patch > > > SHOW CREATE TABLE shows the time zone that the table was created in (if it > contains a TIMESTAMPTZ column). This is also misleading, since it has nothing > to do with the actual data or server or user time zone. > e.g. > {code:java} > hive> set time zone America/Los_Angeles; > hive> create table text_local (ts timestamp with local time zone) stored as > textfile; > hive> show create table text_local; > CREATE TABLE `text_local`( > `ts` timestamp with local time zone('America/Los_Angeles')) > {code} > should be: > {code:java} > hive> show create table text_local; > CREATE TABLE `text_local`( > `ts` timestamp with local time zone) > {code} > This was discussed in the community doc [Consistent timestamp types in Hadoop > SQL > engines|https://docs.google.com/document/d/1gNRww9mZJcHvUDCXklzjFEQGpefsuR_akCDfWsdE35Q/edit?usp=sharing] -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-21095) 'Show create table' should not display a time zone for timestamp with local time zone
[ https://issues.apache.org/jira/browse/HIVE-21095?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16739305#comment-16739305 ] Hive QA commented on HIVE-21095: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12954403/HIVE-21095.2.patch {color:red}ERROR:{color} -1 due to no test(s) being added or modified. {color:red}ERROR:{color} -1 due to 3 failed/errored test(s), 15696 tests executed *Failed tests:* {noformat} TestAlterTableMetadata - did not produce a TEST-*.xml file (likely timed out) (batchId=251) TestReplAcidTablesWithJsonMessage - did not produce a TEST-*.xml file (likely timed out) (batchId=251) TestSemanticAnalyzerHookLoading - did not produce a TEST-*.xml file (likely timed out) (batchId=251) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/15572/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/15572/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-15572/ Messages: {noformat} Executing org.apache.hive.ptest.execution.TestCheckPhase Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.YetusPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase Tests exited with: TestsFailedException: 3 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12954403 - PreCommit-HIVE-Build > 'Show create table' should not display a time zone for timestamp with local > time zone > - > > Key: HIVE-21095 > URL: https://issues.apache.org/jira/browse/HIVE-21095 > Project: Hive > Issue Type: Improvement >Reporter: Karen Coppage >Assignee: Karen Coppage >Priority: Major > Attachments: HIVE-21095.1.patch, HIVE-21095.1.patch, > HIVE-21095.2.patch, HIVE-21095.2.patch > > > SHOW CREATE TABLE shows the time zone that the table was created in (if it > contains a TIMESTAMPTZ column). This is also misleading, since it might have > nothing to do with the actual data. > e.g. > {code:java} > hive> set time zone America/Los_Angeles; > hive> create table text_local (ts timestamp with local time zone) stored as > textfile; > hive> show create table text_local; > CREATE TABLE `text_local`( > `ts` timestamp with local time zone('America/Los_Angeles')) > {code} > should be: > {code:java} > hive> show create table text_local; > CREATE TABLE `text_local`( > `ts` timestamp with local time zone) > {code} > This was discussed in the community doc [Consistent timestamp types in Hadoop > SQL > engines|https://docs.google.com/document/d/1gNRww9mZJcHvUDCXklzjFEQGpefsuR_akCDfWsdE35Q/edit?usp=sharing] -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-21095) 'Show create table' should not display a time zone for timestamp with local time zone
[ https://issues.apache.org/jira/browse/HIVE-21095?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16739277#comment-16739277 ] Hive QA commented on HIVE-21095: | (/) *{color:green}+1 overall{color}* | \\ \\ || Vote || Subsystem || Runtime || Comment || || || || || {color:brown} Prechecks {color} || | {color:green}+1{color} | {color:green} @author {color} | {color:green} 0m 0s{color} | {color:green} The patch does not contain any @author tags. {color} | || || || || {color:brown} master Compile Tests {color} || | {color:blue}0{color} | {color:blue} mvndep {color} | {color:blue} 1m 39s{color} | {color:blue} Maven dependency ordering for branch {color} | | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 6m 36s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 17s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 0m 48s{color} | {color:green} master passed {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 0m 38s{color} | {color:blue} serde in master has 198 extant Findbugs warnings. {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 3m 43s{color} | {color:blue} ql in master has 2309 extant Findbugs warnings. {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 1m 8s{color} | {color:green} master passed {color} | || || || || {color:brown} Patch Compile Tests {color} || | {color:blue}0{color} | {color:blue} mvndep {color} | {color:blue} 0m 25s{color} | {color:blue} Maven dependency ordering for patch {color} | | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 1m 39s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 19s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javac {color} | {color:green} 1m 19s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 0m 48s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} whitespace {color} | {color:green} 0m 0s{color} | {color:green} The patch has no whitespace issues. {color} | | {color:green}+1{color} | {color:green} findbugs {color} | {color:green} 4m 36s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 1m 6s{color} | {color:green} the patch passed {color} | || || || || {color:brown} Other Tests {color} || | {color:green}+1{color} | {color:green} asflicense {color} | {color:green} 0m 13s{color} | {color:green} The patch does not generate ASF License warnings. {color} | | {color:black}{color} | {color:black} {color} | {color:black} 26m 32s{color} | {color:black} {color} | \\ \\ || Subsystem || Report/Notes || | Optional Tests | asflicense javac javadoc findbugs checkstyle compile | | uname | Linux hiveptest-server-upstream 3.16.0-4-amd64 #1 SMP Debian 3.16.36-1+deb8u1 (2016-09-03) x86_64 GNU/Linux | | Build tool | maven | | Personality | /data/hiveptest/working/yetus_PreCommit-HIVE-Build-15572/dev-support/hive-personality.sh | | git revision | master / dcc8950 | | Default Java | 1.8.0_111 | | findbugs | v3.0.0 | | modules | C: serde ql U: . | | Console output | http://104.198.109.242/logs//PreCommit-HIVE-Build-15572/yetus.txt | | Powered by | Apache Yetushttp://yetus.apache.org | This message was automatically generated. > 'Show create table' should not display a time zone for timestamp with local > time zone > - > > Key: HIVE-21095 > URL: https://issues.apache.org/jira/browse/HIVE-21095 > Project: Hive > Issue Type: Improvement >Reporter: Karen Coppage >Assignee: Karen Coppage >Priority: Major > Attachments: HIVE-21095.1.patch, HIVE-21095.1.patch, > HIVE-21095.2.patch, HIVE-21095.2.patch > > > SHOW CREATE TABLE shows the time zone that the table was created in (if it > contains a TIMESTAMPTZ column). This is also misleading, since it might have > nothing to do with the actual data. > e.g. > {code:java} > hive> set time zone America/Los_Angeles; > hive> create table text_local (ts timestamp with local time zone) stored as > textfile; > hive> show create table text_local; > CREATE TABLE `text_local`( > `ts` timestamp with local time zone('America/Los_Angeles')) > {code} > should be: > {code:java} > hive> show create table text_local; > CREATE TABLE `text_local`( > `ts` timestamp with local time zone) > {code} > This was discussed in the community doc [Consistent timestamp types
[jira] [Commented] (HIVE-21095) 'Show create table' should not display a time zone for timestamp with local time zone
[ https://issues.apache.org/jira/browse/HIVE-21095?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16737264#comment-16737264 ] Hive QA commented on HIVE-21095: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12954145/HIVE-21095.2.patch {color:red}ERROR:{color} -1 due to no test(s) being added or modified. {color:red}ERROR:{color} -1 due to 4 failed/errored test(s), 15695 tests executed *Failed tests:* {noformat} TestAlterTableMetadata - did not produce a TEST-*.xml file (likely timed out) (batchId=251) TestReplAcidTablesWithJsonMessage - did not produce a TEST-*.xml file (likely timed out) (batchId=251) TestSemanticAnalyzerHookLoading - did not produce a TEST-*.xml file (likely timed out) (batchId=251) org.apache.hive.jdbc.TestSSL.testMetastoreWithSSL (batchId=258) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/15543/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/15543/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-15543/ Messages: {noformat} Executing org.apache.hive.ptest.execution.TestCheckPhase Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.YetusPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase Tests exited with: TestsFailedException: 4 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12954145 - PreCommit-HIVE-Build > 'Show create table' should not display a time zone for timestamp with local > time zone > - > > Key: HIVE-21095 > URL: https://issues.apache.org/jira/browse/HIVE-21095 > Project: Hive > Issue Type: Improvement >Reporter: Karen Coppage >Assignee: Karen Coppage >Priority: Major > Attachments: HIVE-21095.1.patch, HIVE-21095.1.patch, > HIVE-21095.2.patch > > > SHOW CREATE TABLE shows the time zone that the table was created in (if it > contains a TIMESTAMPTZ column). This is also misleading, since it might have > nothing to do with the actual data. > e.g. > {code:java} > hive> set time zone America/Los_Angeles; > hive> create table text_local (ts timestamp with local time zone) stored as > textfile; > hive> show create table text_local; > CREATE TABLE `text_local`( > `ts` timestamp with local time zone('America/Los_Angeles')) > {code} > should be: > {code:java} > hive> show create table text_local; > CREATE TABLE `text_local`( > `ts` timestamp with local time zone) > {code} > This was discussed in the community doc [Consistent timestamp types in Hadoop > SQL > engines|https://docs.google.com/document/d/1gNRww9mZJcHvUDCXklzjFEQGpefsuR_akCDfWsdE35Q/edit?usp=sharing] -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-21095) 'Show create table' should not display a time zone for timestamp with local time zone
[ https://issues.apache.org/jira/browse/HIVE-21095?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16737225#comment-16737225 ] Hive QA commented on HIVE-21095: | (/) *{color:green}+1 overall{color}* | \\ \\ || Vote || Subsystem || Runtime || Comment || || || || || {color:brown} Prechecks {color} || | {color:green}+1{color} | {color:green} @author {color} | {color:green} 0m 0s{color} | {color:green} The patch does not contain any @author tags. {color} | || || || || {color:brown} master Compile Tests {color} || | {color:blue}0{color} | {color:blue} mvndep {color} | {color:blue} 0m 40s{color} | {color:blue} Maven dependency ordering for branch {color} | | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 8m 6s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 17s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 0m 50s{color} | {color:green} master passed {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 0m 41s{color} | {color:blue} serde in master has 198 extant Findbugs warnings. {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 3m 37s{color} | {color:blue} ql in master has 2310 extant Findbugs warnings. {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 1m 7s{color} | {color:green} master passed {color} | || || || || {color:brown} Patch Compile Tests {color} || | {color:blue}0{color} | {color:blue} mvndep {color} | {color:blue} 0m 26s{color} | {color:blue} Maven dependency ordering for patch {color} | | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 1m 40s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 19s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javac {color} | {color:green} 1m 19s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 0m 48s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} whitespace {color} | {color:green} 0m 0s{color} | {color:green} The patch has no whitespace issues. {color} | | {color:green}+1{color} | {color:green} findbugs {color} | {color:green} 4m 33s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 1m 7s{color} | {color:green} the patch passed {color} | || || || || {color:brown} Other Tests {color} || | {color:green}+1{color} | {color:green} asflicense {color} | {color:green} 0m 13s{color} | {color:green} The patch does not generate ASF License warnings. {color} | | {color:black}{color} | {color:black} {color} | {color:black} 26m 57s{color} | {color:black} {color} | \\ \\ || Subsystem || Report/Notes || | Optional Tests | asflicense javac javadoc findbugs checkstyle compile | | uname | Linux hiveptest-server-upstream 3.16.0-4-amd64 #1 SMP Debian 3.16.36-1+deb8u1 (2016-09-03) x86_64 GNU/Linux | | Build tool | maven | | Personality | /data/hiveptest/working/yetus_PreCommit-HIVE-Build-15543/dev-support/hive-personality.sh | | git revision | master / e92df8d | | Default Java | 1.8.0_111 | | findbugs | v3.0.0 | | modules | C: serde ql U: . | | Console output | http://104.198.109.242/logs//PreCommit-HIVE-Build-15543/yetus.txt | | Powered by | Apache Yetushttp://yetus.apache.org | This message was automatically generated. > 'Show create table' should not display a time zone for timestamp with local > time zone > - > > Key: HIVE-21095 > URL: https://issues.apache.org/jira/browse/HIVE-21095 > Project: Hive > Issue Type: Improvement >Reporter: Karen Coppage >Assignee: Karen Coppage >Priority: Major > Attachments: HIVE-21095.1.patch, HIVE-21095.1.patch, > HIVE-21095.2.patch > > > SHOW CREATE TABLE shows the time zone that the table was created in (if it > contains a TIMESTAMPTZ column). This is also misleading, since it might have > nothing to do with the actual data. > e.g. > {code:java} > hive> set time zone America/Los_Angeles; > hive> create table text_local (ts timestamp with local time zone) stored as > textfile; > hive> show create table text_local; > CREATE TABLE `text_local`( > `ts` timestamp with local time zone('America/Los_Angeles')) > {code} > should be: > {code:java} > hive> show create table text_local; > CREATE TABLE `text_local`( > `ts` timestamp with local time zone) > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-21095) 'Show create table' should not display a time zone for timestamp with local time zone
[ https://issues.apache.org/jira/browse/HIVE-21095?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16736979#comment-16736979 ] Hive QA commented on HIVE-21095: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12954129/HIVE-21095.1.patch {color:red}ERROR:{color} -1 due to no test(s) being added or modified. {color:red}ERROR:{color} -1 due to 5 failed/errored test(s), 15693 tests executed *Failed tests:* {noformat} TestAlterTableMetadata - did not produce a TEST-*.xml file (likely timed out) (batchId=251) TestReplAcidTablesWithJsonMessage - did not produce a TEST-*.xml file (likely timed out) (batchId=251) TestReplicationScenariosIncrementalLoadAcidTables - did not produce a TEST-*.xml file (likely timed out) (batchId=249) TestSemanticAnalyzerHookLoading - did not produce a TEST-*.xml file (likely timed out) (batchId=251) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[default_constraint] (batchId=169) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/15541/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/15541/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-15541/ Messages: {noformat} Executing org.apache.hive.ptest.execution.TestCheckPhase Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.YetusPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase Tests exited with: TestsFailedException: 5 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12954129 - PreCommit-HIVE-Build > 'Show create table' should not display a time zone for timestamp with local > time zone > - > > Key: HIVE-21095 > URL: https://issues.apache.org/jira/browse/HIVE-21095 > Project: Hive > Issue Type: Improvement >Reporter: Karen Coppage >Assignee: Karen Coppage >Priority: Major > Attachments: HIVE-21095.1.patch, HIVE-21095.1.patch > > > SHOW CREATE TABLE shows the time zone that the table was created in (if it > contains a TIMESTAMPTZ column). This is also misleading, since it might have > nothing to do with the actual data. > e.g. > {code:java} > hive> set time zone America/Los_Angeles; > hive> create table text_local (ts timestamp with local time zone) stored as > textfile; > hive> show create table text_local; > CREATE TABLE `text_local`( > `ts` timestamp with local time zone('America/Los_Angeles')) > {code} > should be: > {code:java} > hive> show create table text_local; > CREATE TABLE `text_local`( > `ts` timestamp with local time zone) > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-21095) 'Show create table' should not display a time zone for timestamp with local time zone
[ https://issues.apache.org/jira/browse/HIVE-21095?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16736918#comment-16736918 ] Hive QA commented on HIVE-21095: | (/) *{color:green}+1 overall{color}* | \\ \\ || Vote || Subsystem || Runtime || Comment || || || || || {color:brown} Prechecks {color} || | {color:green}+1{color} | {color:green} @author {color} | {color:green} 0m 0s{color} | {color:green} The patch does not contain any @author tags. {color} | || || || || {color:brown} master Compile Tests {color} || | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 8m 9s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 0m 16s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 0m 14s{color} | {color:green} master passed {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 0m 35s{color} | {color:blue} serde in master has 198 extant Findbugs warnings. {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 14s{color} | {color:green} master passed {color} | || || || || {color:brown} Patch Compile Tests {color} || | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 0m 17s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 0m 17s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javac {color} | {color:green} 0m 17s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 0m 13s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} whitespace {color} | {color:green} 0m 1s{color} | {color:green} The patch has no whitespace issues. {color} | | {color:green}+1{color} | {color:green} findbugs {color} | {color:green} 0m 44s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 14s{color} | {color:green} the patch passed {color} | || || || || {color:brown} Other Tests {color} || | {color:green}+1{color} | {color:green} asflicense {color} | {color:green} 0m 12s{color} | {color:green} The patch does not generate ASF License warnings. {color} | | {color:black}{color} | {color:black} {color} | {color:black} 11m 52s{color} | {color:black} {color} | \\ \\ || Subsystem || Report/Notes || | Optional Tests | asflicense javac javadoc findbugs checkstyle compile | | uname | Linux hiveptest-server-upstream 3.16.0-4-amd64 #1 SMP Debian 3.16.36-1+deb8u1 (2016-09-03) x86_64 GNU/Linux | | Build tool | maven | | Personality | /data/hiveptest/working/yetus_PreCommit-HIVE-Build-15541/dev-support/hive-personality.sh | | git revision | master / b3ef75e | | Default Java | 1.8.0_111 | | findbugs | v3.0.0 | | modules | C: serde U: serde | | Console output | http://104.198.109.242/logs//PreCommit-HIVE-Build-15541/yetus.txt | | Powered by | Apache Yetushttp://yetus.apache.org | This message was automatically generated. > 'Show create table' should not display a time zone for timestamp with local > time zone > - > > Key: HIVE-21095 > URL: https://issues.apache.org/jira/browse/HIVE-21095 > Project: Hive > Issue Type: Improvement >Reporter: Karen Coppage >Assignee: Karen Coppage >Priority: Major > Attachments: HIVE-21095.1.patch, HIVE-21095.1.patch > > > SHOW CREATE TABLE shows the time zone that the table was created in (if it > contains a TIMESTAMPTZ column). This is also misleading, since it might have > nothing to do with the actual data. > e.g. > {code:java} > hive> set time zone America/Los_Angeles; > hive> create table text_local (ts timestamp with local time zone) stored as > textfile; > hive> show create table text_local; > CREATE TABLE `text_local`( > `ts` timestamp with local time zone('America/Los_Angeles')) > {code} > should be: > {code:java} > hive> show create table text_local; > CREATE TABLE `text_local`( > `ts` timestamp with local time zone) > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)