[jira] [Assigned] (HIVE-14525) beeline still writing log data to stdout as of version 2.1.0
[ https://issues.apache.org/jira/browse/HIVE-14525?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Miklos Csanady reassigned HIVE-14525: - Assignee: (was: Miklos Csanady) > beeline still writing log data to stdout as of version 2.1.0 > > > Key: HIVE-14525 > URL: https://issues.apache.org/jira/browse/HIVE-14525 > Project: Hive > Issue Type: Bug > Components: Beeline >Affects Versions: 2.1.0, 2.2.0 >Reporter: stephen sprague > Labels: beeline > Attachments: HIVE-14525.1.patch, HIVE-14525.2.patch, > HIVE-14525.3.patch, HIVE-14525.4.patch, HIVE-14525.patch > > > simple test. note that i'm looking to get a tsv file back. > {code} > $ beeline -u dwrdevnn1 --showHeader=false --outputformat=tsv22>stderr > > select count(*) > > from default.dual; > > SQL > {code} > instead i get this in stdout: > {code} > $ cat stdout > 0: jdbc:hive2://dwrdevnn1.sv2.trulia.com:1000> select count(*) > . . . . . . . . . . . . . . . . . . . . . . .> from default.dual; > 0 > 0: jdbc:hive2://dwrdevnn1.sv2.trulia.com:1000> > {code} > i should only get one row which is the *result* of the query (which is 0) - > not the ovthe loggy kind of lines you see above. that stuff goes to stderr my > friends. > also i refer to this ticket b/c the last comment suggested so - its close but > not exactly the same. > https://issues.apache.org/jira/browse/HIVE-14183 -- This message was sent by Atlassian JIRA (v6.4.14#64029)
[jira] [Commented] (HIVE-15550) fix arglist logging in schematool
[ https://issues.apache.org/jira/browse/HIVE-15550?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15860010#comment-15860010 ] Miklos Csanady commented on HIVE-15550: --- In the final version the beeline/src/test/org/apache/hive/beeline/TestHiveSchemaTool.java file is missing. (Here: https://github.com/apache/hive/tree/master/beeline/src/test/org/apache/hive/beeline) Is it intentional? git log: commit 16ed90aefd0157af750af0ddbf7741ab715b1034 Author: Anishek AgarwalDate: Thu Jan 26 21:57:41 2017 -0800 HIVE-15550 : fix arglist logging in schematool (Anishek Agarwal via Thejas Nair) commit 3792a4a61805f005d88ae3fc5da2a528be2ca212 Author: Jesus Camacho Rodriguez Date: Wed Jan 18 10:05:56 2017 + Revert "HIVE-15550: fix arglist logging in schematool (Anishek Agarwal via Thejas Nair)" This reverts commit ea87e0f26112f0cdbe2fa06e3090fb7b49d81569. commit 85be4250c881865e183d8bdd366b318309162ef9 Author: Jesus Camacho Rodriguez Date: Wed Jan 18 10:05:30 2017 + Revert "Update errata.txt for HIVE-15550" This reverts commit a6bba80e15df4dc5f1b01ae519dea23ccc497945. commit f225d09211dfede75398116cd4ae5f265257f743 Author: Jesus Camacho Rodriguez Date: Wed Jan 18 10:05:18 2017 + Revert "HIVE-15550 : fix arglist logging in schematool - add missing test file" This reverts commit 8ff096548d0f94f9abb5361cce9539e71613e5d8. commit 8ff096548d0f94f9abb5361cce9539e71613e5d8 Author: Anishek Agarwal Date: Tue Jan 17 21:13:55 2017 -0800 HIVE-15550 : fix arglist logging in schematool - add missing test file commit a6bba80e15df4dc5f1b01ae519dea23ccc497945 Author: Thejas M Nair Date: Tue Jan 17 15:23:29 2017 -0800 Update errata.txt for HIVE-15550 > fix arglist logging in schematool > - > > Key: HIVE-15550 > URL: https://issues.apache.org/jira/browse/HIVE-15550 > Project: Hive > Issue Type: Improvement > Components: Beeline >Affects Versions: 2.1.1 >Reporter: anishek >Assignee: anishek >Priority: Minor > Fix For: 2.2.0 > > Attachments: HIVE-15550.1.patch, HIVE-15550.1.patch > > > In DEBUG mode schemaTool prints the password to log file. > This is also seen if the user includes --verbose option. -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Updated] (HIVE-15176) Small typo in hiveserver2 webui
[ https://issues.apache.org/jira/browse/HIVE-15176?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Miklos Csanady updated HIVE-15176: -- Status: Patch Available (was: Open) > Small typo in hiveserver2 webui > --- > > Key: HIVE-15176 > URL: https://issues.apache.org/jira/browse/HIVE-15176 > Project: Hive > Issue Type: Bug > Components: HiveServer2, Web UI >Reporter: Miklos Csanady >Assignee: Miklos Csanady >Priority: Trivial > Attachments: HIVE-15176.patch > > > I found a small typo in webui for hiveserver2 > The Waited is happened to spell Wtaited. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HIVE-15176) Small typo in hiveserver2 webui
[ https://issues.apache.org/jira/browse/HIVE-15176?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Miklos Csanady updated HIVE-15176: -- Attachment: HIVE-15176.patch > Small typo in hiveserver2 webui > --- > > Key: HIVE-15176 > URL: https://issues.apache.org/jira/browse/HIVE-15176 > Project: Hive > Issue Type: Bug > Components: HiveServer2, Web UI >Reporter: Miklos Csanady >Assignee: Miklos Csanady >Priority: Trivial > Attachments: HIVE-15176.patch > > > I found a small typo in webui for hiveserver2 > The Waited is happened to spell Wtaited. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Assigned] (HIVE-14541) Beeline does not prompt for username and password properly
[ https://issues.apache.org/jira/browse/HIVE-14541?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Miklos Csanady reassigned HIVE-14541: - Assignee: Vihang Karajgaonkar (was: Miklos Csanady) I have no access to close it. > Beeline does not prompt for username and password properly > -- > > Key: HIVE-14541 > URL: https://issues.apache.org/jira/browse/HIVE-14541 > Project: Hive > Issue Type: Bug > Components: Beeline >Reporter: Vihang Karajgaonkar >Assignee: Vihang Karajgaonkar > > In the default mode, when we connect using !connect > jdbc:hive2://localhost:1 (without providing user and password) beeling > prompts for it as expected. > But when we use beeline -u "url" and do not provide -n or -p arguments, it > does not prompt for the user/password > {noformat} > $ ./beeline -u jdbc:hive2://localhost:1 > SLF4J: Class path contains multiple SLF4J bindings. > SLF4J: Found binding in > [jar:file:/Users/vihang/work/src/upstream/hive/packaging/target/apache-hive-2.2.0-SNAPSHOT-bin/apache-hive-2.2.0-SNAPSHOT-bin/lib/log4j-slf4j-impl-2.6.2.jar!/org/slf4j/impl/StaticLoggerBinder.class] > SLF4J: Found binding in > [jar:file:/usr/local/Cellar/hadoop/2.7.2/libexec/share/hadoop/common/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class] > SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an > explanation. > SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory] > Connecting to jdbc:hive2://localhost:1 > Connected to: Apache Hive (version 2.2.0-SNAPSHOT) > Driver: Hive JDBC (version 2.2.0-SNAPSHOT) > 16/08/15 18:09:15 [main]: WARN jdbc.HiveConnection: Request to set autoCommit > to false; Hive does not support autoCommit=false. > Transaction isolation: TRANSACTION_REPEATABLE_READ > Beeline version 2.2.0-SNAPSHOT by Apache Hive > 0: jdbc:hive2://localhost:1> !quit > Closing: 0: jdbc:hive2://localhost:1 > {noformat} > {noformat} > $ ./beeline > Beeline version 2.2.0-SNAPSHOT by Apache Hive > beeline> !connect "jdbc:hive2://localhost:1" > SLF4J: Class path contains multiple SLF4J bindings. > SLF4J: Found binding in > [jar:file:/Users/vihang/work/src/upstream/hive/packaging/target/apache-hive-2.2.0-SNAPSHOT-bin/apache-hive-2.2.0-SNAPSHOT-bin/lib/log4j-slf4j-impl-2.6.2.jar!/org/slf4j/impl/StaticLoggerBinder.class] > SLF4J: Found binding in > [jar:file:/usr/local/Cellar/hadoop/2.7.2/libexec/share/hadoop/common/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class] > SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an > explanation. > SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory] > Connecting to jdbc:hive2://localhost:1 > Enter username for jdbc:hive2://localhost:1: hive > Enter password for jdbc:hive2://localhost:1: > Connected to: Apache Hive (version 2.2.0-SNAPSHOT) > Driver: Hive JDBC (version 2.2.0-SNAPSHOT) > 16/08/15 18:09:03 [main]: WARN jdbc.HiveConnection: Request to set autoCommit > to false; Hive does not support autoCommit=false. > Transaction isolation: TRANSACTION_REPEATABLE_READ > 0: jdbc:hive2://localhost:1> !quit > Closing: 0: jdbc:hive2://localhost:1 > {noformat} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-14541) Beeline does not prompt for username and password properly
[ https://issues.apache.org/jira/browse/HIVE-14541?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15651085#comment-15651085 ] Miklos Csanady commented on HIVE-14541: --- Let me clarify: It should ask for username if -u parameter is given without username AND (no -n connection parameter given and (no javax.jdo.option.ConnectionUserName given and no ConnectionUserName parameter found.)) For password prompt: if -p given without value OR (-u parameter is given with no passwd AND none of javax.jdo.option.ConnectionPassword and ConnectionPassword found.) [~vihangk1] Am I correct? Miklos > Beeline does not prompt for username and password properly > -- > > Key: HIVE-14541 > URL: https://issues.apache.org/jira/browse/HIVE-14541 > Project: Hive > Issue Type: Bug > Components: Beeline >Reporter: Vihang Karajgaonkar >Assignee: Miklos Csanady > > In the default mode, when we connect using !connect > jdbc:hive2://localhost:1 (without providing user and password) beeling > prompts for it as expected. > But when we use beeline -u "url" and do not provide -n or -p arguments, it > does not prompt for the user/password > {noformat} > $ ./beeline -u jdbc:hive2://localhost:1 > SLF4J: Class path contains multiple SLF4J bindings. > SLF4J: Found binding in > [jar:file:/Users/vihang/work/src/upstream/hive/packaging/target/apache-hive-2.2.0-SNAPSHOT-bin/apache-hive-2.2.0-SNAPSHOT-bin/lib/log4j-slf4j-impl-2.6.2.jar!/org/slf4j/impl/StaticLoggerBinder.class] > SLF4J: Found binding in > [jar:file:/usr/local/Cellar/hadoop/2.7.2/libexec/share/hadoop/common/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class] > SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an > explanation. > SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory] > Connecting to jdbc:hive2://localhost:1 > Connected to: Apache Hive (version 2.2.0-SNAPSHOT) > Driver: Hive JDBC (version 2.2.0-SNAPSHOT) > 16/08/15 18:09:15 [main]: WARN jdbc.HiveConnection: Request to set autoCommit > to false; Hive does not support autoCommit=false. > Transaction isolation: TRANSACTION_REPEATABLE_READ > Beeline version 2.2.0-SNAPSHOT by Apache Hive > 0: jdbc:hive2://localhost:1> !quit > Closing: 0: jdbc:hive2://localhost:1 > {noformat} > {noformat} > $ ./beeline > Beeline version 2.2.0-SNAPSHOT by Apache Hive > beeline> !connect "jdbc:hive2://localhost:1" > SLF4J: Class path contains multiple SLF4J bindings. > SLF4J: Found binding in > [jar:file:/Users/vihang/work/src/upstream/hive/packaging/target/apache-hive-2.2.0-SNAPSHOT-bin/apache-hive-2.2.0-SNAPSHOT-bin/lib/log4j-slf4j-impl-2.6.2.jar!/org/slf4j/impl/StaticLoggerBinder.class] > SLF4J: Found binding in > [jar:file:/usr/local/Cellar/hadoop/2.7.2/libexec/share/hadoop/common/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class] > SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an > explanation. > SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory] > Connecting to jdbc:hive2://localhost:1 > Enter username for jdbc:hive2://localhost:1: hive > Enter password for jdbc:hive2://localhost:1: > Connected to: Apache Hive (version 2.2.0-SNAPSHOT) > Driver: Hive JDBC (version 2.2.0-SNAPSHOT) > 16/08/15 18:09:03 [main]: WARN jdbc.HiveConnection: Request to set autoCommit > to false; Hive does not support autoCommit=false. > Transaction isolation: TRANSACTION_REPEATABLE_READ > 0: jdbc:hive2://localhost:1> !quit > Closing: 0: jdbc:hive2://localhost:1 > {noformat} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Assigned] (HIVE-14541) Beeline does not prompt for username and password properly
[ https://issues.apache.org/jira/browse/HIVE-14541?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Miklos Csanady reassigned HIVE-14541: - Assignee: Miklos Csanady > Beeline does not prompt for username and password properly > -- > > Key: HIVE-14541 > URL: https://issues.apache.org/jira/browse/HIVE-14541 > Project: Hive > Issue Type: Bug > Components: Beeline >Reporter: Vihang Karajgaonkar >Assignee: Miklos Csanady > > In the default mode, when we connect using !connect > jdbc:hive2://localhost:1 (without providing user and password) beeling > prompts for it as expected. > But when we use beeline -u "url" and do not provide -n or -p arguments, it > does not prompt for the user/password > {noformat} > $ ./beeline -u jdbc:hive2://localhost:1 > SLF4J: Class path contains multiple SLF4J bindings. > SLF4J: Found binding in > [jar:file:/Users/vihang/work/src/upstream/hive/packaging/target/apache-hive-2.2.0-SNAPSHOT-bin/apache-hive-2.2.0-SNAPSHOT-bin/lib/log4j-slf4j-impl-2.6.2.jar!/org/slf4j/impl/StaticLoggerBinder.class] > SLF4J: Found binding in > [jar:file:/usr/local/Cellar/hadoop/2.7.2/libexec/share/hadoop/common/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class] > SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an > explanation. > SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory] > Connecting to jdbc:hive2://localhost:1 > Connected to: Apache Hive (version 2.2.0-SNAPSHOT) > Driver: Hive JDBC (version 2.2.0-SNAPSHOT) > 16/08/15 18:09:15 [main]: WARN jdbc.HiveConnection: Request to set autoCommit > to false; Hive does not support autoCommit=false. > Transaction isolation: TRANSACTION_REPEATABLE_READ > Beeline version 2.2.0-SNAPSHOT by Apache Hive > 0: jdbc:hive2://localhost:1> !quit > Closing: 0: jdbc:hive2://localhost:1 > {noformat} > {noformat} > $ ./beeline > Beeline version 2.2.0-SNAPSHOT by Apache Hive > beeline> !connect "jdbc:hive2://localhost:1" > SLF4J: Class path contains multiple SLF4J bindings. > SLF4J: Found binding in > [jar:file:/Users/vihang/work/src/upstream/hive/packaging/target/apache-hive-2.2.0-SNAPSHOT-bin/apache-hive-2.2.0-SNAPSHOT-bin/lib/log4j-slf4j-impl-2.6.2.jar!/org/slf4j/impl/StaticLoggerBinder.class] > SLF4J: Found binding in > [jar:file:/usr/local/Cellar/hadoop/2.7.2/libexec/share/hadoop/common/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class] > SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an > explanation. > SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory] > Connecting to jdbc:hive2://localhost:1 > Enter username for jdbc:hive2://localhost:1: hive > Enter password for jdbc:hive2://localhost:1: > Connected to: Apache Hive (version 2.2.0-SNAPSHOT) > Driver: Hive JDBC (version 2.2.0-SNAPSHOT) > 16/08/15 18:09:03 [main]: WARN jdbc.HiveConnection: Request to set autoCommit > to false; Hive does not support autoCommit=false. > Transaction isolation: TRANSACTION_REPEATABLE_READ > 0: jdbc:hive2://localhost:1> !quit > Closing: 0: jdbc:hive2://localhost:1 > {noformat} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Assigned] (HIVE-10701) Escape apostrophe not work properly
[ https://issues.apache.org/jira/browse/HIVE-10701?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Miklos Csanady reassigned HIVE-10701: - Assignee: (was: Miklos Csanady) can be closed > Escape apostrophe not work properly > --- > > Key: HIVE-10701 > URL: https://issues.apache.org/jira/browse/HIVE-10701 > Project: Hive > Issue Type: Bug > Components: Hive >Affects Versions: 0.12.0, 0.13.0, 0.14.0 >Reporter: Tracy Y >Priority: Minor > > SELECT 'S''2' FROM table return S2 instead of S'2 > The apostrophe suppose to be escaped by the single quote in front. > Thanks. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Assigned] (HIVE-9530) constant * column is null interpreted as constant * boolean
[ https://issues.apache.org/jira/browse/HIVE-9530?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Miklos Csanady reassigned HIVE-9530: Assignee: (was: Miklos Csanady) Could be closed > constant * column is null interpreted as constant * boolean > --- > > Key: HIVE-9530 > URL: https://issues.apache.org/jira/browse/HIVE-9530 > Project: Hive > Issue Type: Bug > Components: SQL >Affects Versions: 0.14.0 >Reporter: N Campbell >Priority: Minor > > {code} > select c1 from tversion where 1 * cnnull is null > FAILED: SemanticException [Error 10014]: Line 1:30 Wrong arguments 'cnnull': > No matching method for class > org.apache.hadoop.hive.ql.udf.generic.GenericUDFOPMultiply with (int, boolean) > create table if not exists TVERSION ( > RNUM int, > C1 int, > CVER char(6), > CNNULL int, > CCNULL char(1) > ) > ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' LINES TERMINATED BY '\n' > STORED AS TEXTFILE ; > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Assigned] (HIVE-14049) Password prompt in Beeline is continuously printed
[ https://issues.apache.org/jira/browse/HIVE-14049?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Miklos Csanady reassigned HIVE-14049: - Assignee: (was: Miklos Csanady) > Password prompt in Beeline is continuously printed > -- > > Key: HIVE-14049 > URL: https://issues.apache.org/jira/browse/HIVE-14049 > Project: Hive > Issue Type: Bug > Components: Beeline >Affects Versions: 2.0.1 >Reporter: Abdullah Yousufi > > I'm experiencing this issue with a Mac, which was not occurring until > recently. > {code} > Beeline version 2.2.0-SNAPSHOT by Apache Hive > beeline> !connect jdbc:hive2://localhost:1 > Connecting to jdbc:hive2://localhost:1 > Enter username for jdbc:hive2://localhost:1: hive > Enter password for jdbc:hive2://localhost:1: > Enter password for jdbc:hive2://localhost:1: > Enter password for jdbc:hive2://localhost:1: > ... > {code} > The 'Enter password for jdbc:hive2://localhost:1:' line continues to > print until enter is hit. From looking at the code in Commands.java (lines > 1413-1420), it's not quite clear why this happens on the second call to > readLine()) : > {code} > if (username == null) { > username = beeLine.getConsoleReader().readLine("Enter username for " + url > + ": "); > } > props.setProperty("user", username); > if (password == null) { > password = beeLine.getConsoleReader().readLine("Enter password for " + url > + ": ", > new Character('*')); > } > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Work started] (HIVE-14049) Password prompt in Beeline is continuously printed
[ https://issues.apache.org/jira/browse/HIVE-14049?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on HIVE-14049 started by Miklos Csanady. - > Password prompt in Beeline is continuously printed > -- > > Key: HIVE-14049 > URL: https://issues.apache.org/jira/browse/HIVE-14049 > Project: Hive > Issue Type: Bug > Components: Beeline >Affects Versions: 2.0.1 >Reporter: Abdullah Yousufi >Assignee: Miklos Csanady > > I'm experiencing this issue with a Mac, which was not occurring until > recently. > {code} > Beeline version 2.2.0-SNAPSHOT by Apache Hive > beeline> !connect jdbc:hive2://localhost:1 > Connecting to jdbc:hive2://localhost:1 > Enter username for jdbc:hive2://localhost:1: hive > Enter password for jdbc:hive2://localhost:1: > Enter password for jdbc:hive2://localhost:1: > Enter password for jdbc:hive2://localhost:1: > ... > {code} > The 'Enter password for jdbc:hive2://localhost:1:' line continues to > print until enter is hit. From looking at the code in Commands.java (lines > 1413-1420), it's not quite clear why this happens on the second call to > readLine()) : > {code} > if (username == null) { > username = beeLine.getConsoleReader().readLine("Enter username for " + url > + ": "); > } > props.setProperty("user", username); > if (password == null) { > password = beeLine.getConsoleReader().readLine("Enter password for " + url > + ": ", > new Character('*')); > } > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Work stopped] (HIVE-14049) Password prompt in Beeline is continuously printed
[ https://issues.apache.org/jira/browse/HIVE-14049?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on HIVE-14049 stopped by Miklos Csanady. - > Password prompt in Beeline is continuously printed > -- > > Key: HIVE-14049 > URL: https://issues.apache.org/jira/browse/HIVE-14049 > Project: Hive > Issue Type: Bug > Components: Beeline >Affects Versions: 2.0.1 >Reporter: Abdullah Yousufi >Assignee: Miklos Csanady > > I'm experiencing this issue with a Mac, which was not occurring until > recently. > {code} > Beeline version 2.2.0-SNAPSHOT by Apache Hive > beeline> !connect jdbc:hive2://localhost:1 > Connecting to jdbc:hive2://localhost:1 > Enter username for jdbc:hive2://localhost:1: hive > Enter password for jdbc:hive2://localhost:1: > Enter password for jdbc:hive2://localhost:1: > Enter password for jdbc:hive2://localhost:1: > ... > {code} > The 'Enter password for jdbc:hive2://localhost:1:' line continues to > print until enter is hit. From looking at the code in Commands.java (lines > 1413-1420), it's not quite clear why this happens on the second call to > readLine()) : > {code} > if (username == null) { > username = beeLine.getConsoleReader().readLine("Enter username for " + url > + ": "); > } > props.setProperty("user", username); > if (password == null) { > password = beeLine.getConsoleReader().readLine("Enter password for " + url > + ": ", > new Character('*')); > } > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-14049) Password prompt in Beeline is continuously printed
[ https://issues.apache.org/jira/browse/HIVE-14049?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15522443#comment-15522443 ] Miklos Csanady commented on HIVE-14049: --- If you still have this issue, please feel free to reopen this. > Password prompt in Beeline is continuously printed > -- > > Key: HIVE-14049 > URL: https://issues.apache.org/jira/browse/HIVE-14049 > Project: Hive > Issue Type: Bug > Components: Beeline >Affects Versions: 2.0.1 >Reporter: Abdullah Yousufi >Assignee: Miklos Csanady > > I'm experiencing this issue with a Mac, which was not occurring until > recently. > {code} > Beeline version 2.2.0-SNAPSHOT by Apache Hive > beeline> !connect jdbc:hive2://localhost:1 > Connecting to jdbc:hive2://localhost:1 > Enter username for jdbc:hive2://localhost:1: hive > Enter password for jdbc:hive2://localhost:1: > Enter password for jdbc:hive2://localhost:1: > Enter password for jdbc:hive2://localhost:1: > ... > {code} > The 'Enter password for jdbc:hive2://localhost:1:' line continues to > print until enter is hit. From looking at the code in Commands.java (lines > 1413-1420), it's not quite clear why this happens on the second call to > readLine()) : > {code} > if (username == null) { > username = beeLine.getConsoleReader().readLine("Enter username for " + url > + ": "); > } > props.setProperty("user", username); > if (password == null) { > password = beeLine.getConsoleReader().readLine("Enter password for " + url > + ": ", > new Character('*')); > } > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Work started] (HIVE-14049) Password prompt in Beeline is continuously printed
[ https://issues.apache.org/jira/browse/HIVE-14049?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on HIVE-14049 started by Miklos Csanady. - > Password prompt in Beeline is continuously printed > -- > > Key: HIVE-14049 > URL: https://issues.apache.org/jira/browse/HIVE-14049 > Project: Hive > Issue Type: Bug > Components: Beeline >Affects Versions: 2.0.1 >Reporter: Abdullah Yousufi >Assignee: Miklos Csanady > > I'm experiencing this issue with a Mac, which was not occurring until > recently. > {code} > Beeline version 2.2.0-SNAPSHOT by Apache Hive > beeline> !connect jdbc:hive2://localhost:1 > Connecting to jdbc:hive2://localhost:1 > Enter username for jdbc:hive2://localhost:1: hive > Enter password for jdbc:hive2://localhost:1: > Enter password for jdbc:hive2://localhost:1: > Enter password for jdbc:hive2://localhost:1: > ... > {code} > The 'Enter password for jdbc:hive2://localhost:1:' line continues to > print until enter is hit. From looking at the code in Commands.java (lines > 1413-1420), it's not quite clear why this happens on the second call to > readLine()) : > {code} > if (username == null) { > username = beeLine.getConsoleReader().readLine("Enter username for " + url > + ": "); > } > props.setProperty("user", username); > if (password == null) { > password = beeLine.getConsoleReader().readLine("Enter password for " + url > + ": ", > new Character('*')); > } > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Assigned] (HIVE-14049) Password prompt in Beeline is continuously printed
[ https://issues.apache.org/jira/browse/HIVE-14049?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Miklos Csanady reassigned HIVE-14049: - Assignee: Miklos Csanady > Password prompt in Beeline is continuously printed > -- > > Key: HIVE-14049 > URL: https://issues.apache.org/jira/browse/HIVE-14049 > Project: Hive > Issue Type: Bug > Components: Beeline >Affects Versions: 2.0.1 >Reporter: Abdullah Yousufi >Assignee: Miklos Csanady > > I'm experiencing this issue with a Mac, which was not occurring until > recently. > {code} > Beeline version 2.2.0-SNAPSHOT by Apache Hive > beeline> !connect jdbc:hive2://localhost:1 > Connecting to jdbc:hive2://localhost:1 > Enter username for jdbc:hive2://localhost:1: hive > Enter password for jdbc:hive2://localhost:1: > Enter password for jdbc:hive2://localhost:1: > Enter password for jdbc:hive2://localhost:1: > ... > {code} > The 'Enter password for jdbc:hive2://localhost:1:' line continues to > print until enter is hit. From looking at the code in Commands.java (lines > 1413-1420), it's not quite clear why this happens on the second call to > readLine()) : > {code} > if (username == null) { > username = beeLine.getConsoleReader().readLine("Enter username for " + url > + ": "); > } > props.setProperty("user", username); > if (password == null) { > password = beeLine.getConsoleReader().readLine("Enter password for " + url > + ": ", > new Character('*')); > } > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Work started] (HIVE-9530) constant * column is null interpreted as constant * boolean
[ https://issues.apache.org/jira/browse/HIVE-9530?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on HIVE-9530 started by Miklos Csanady. > constant * column is null interpreted as constant * boolean > --- > > Key: HIVE-9530 > URL: https://issues.apache.org/jira/browse/HIVE-9530 > Project: Hive > Issue Type: Bug > Components: SQL >Affects Versions: 0.14.0 >Reporter: N Campbell >Assignee: Miklos Csanady >Priority: Minor > > {code} > select c1 from tversion where 1 * cnnull is null > FAILED: SemanticException [Error 10014]: Line 1:30 Wrong arguments 'cnnull': > No matching method for class > org.apache.hadoop.hive.ql.udf.generic.GenericUDFOPMultiply with (int, boolean) > create table if not exists TVERSION ( > RNUM int, > C1 int, > CVER char(6), > CNNULL int, > CCNULL char(1) > ) > ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' LINES TERMINATED BY '\n' > STORED AS TEXTFILE ; > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Assigned] (HIVE-9530) constant * column is null interpreted as constant * boolean
[ https://issues.apache.org/jira/browse/HIVE-9530?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Miklos Csanady reassigned HIVE-9530: Assignee: Miklos Csanady > constant * column is null interpreted as constant * boolean > --- > > Key: HIVE-9530 > URL: https://issues.apache.org/jira/browse/HIVE-9530 > Project: Hive > Issue Type: Bug > Components: SQL >Affects Versions: 0.14.0 >Reporter: N Campbell >Assignee: Miklos Csanady >Priority: Minor > > {code} > select c1 from tversion where 1 * cnnull is null > FAILED: SemanticException [Error 10014]: Line 1:30 Wrong arguments 'cnnull': > No matching method for class > org.apache.hadoop.hive.ql.udf.generic.GenericUDFOPMultiply with (int, boolean) > create table if not exists TVERSION ( > RNUM int, > C1 int, > CVER char(6), > CNNULL int, > CCNULL char(1) > ) > ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' LINES TERMINATED BY '\n' > STORED AS TEXTFILE ; > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-9530) constant * column is null interpreted as constant * boolean
[ https://issues.apache.org/jira/browse/HIVE-9530?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15506778#comment-15506778 ] Miklos Csanady commented on HIVE-9530: -- Use brackets to prevent this error. Your command it is interpreted like this: {code} select c1 from tversion where 1 * ( cnull is null ); {code} You should use this instead: {code} select c1 from tversion where ( 1 * cnnull ) is null; OK +-+ | c1 | +-+ +-+ {code} > constant * column is null interpreted as constant * boolean > --- > > Key: HIVE-9530 > URL: https://issues.apache.org/jira/browse/HIVE-9530 > Project: Hive > Issue Type: Bug > Components: SQL >Affects Versions: 0.14.0 >Reporter: N Campbell >Priority: Minor > > {code} > select c1 from tversion where 1 * cnnull is null > FAILED: SemanticException [Error 10014]: Line 1:30 Wrong arguments 'cnnull': > No matching method for class > org.apache.hadoop.hive.ql.udf.generic.GenericUDFOPMultiply with (int, boolean) > create table if not exists TVERSION ( > RNUM int, > C1 int, > CVER char(6), > CNNULL int, > CCNULL char(1) > ) > ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' LINES TERMINATED BY '\n' > STORED AS TEXTFILE ; > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Comment Edited] (HIVE-10701) Escape apostrophe not work properly
[ https://issues.apache.org/jira/browse/HIVE-10701?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15506651#comment-15506651 ] Miklos Csanady edited comment on HIVE-10701 at 9/20/16 2:11 PM: According to https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Types#LanguageManualTypes-string "Hive uses C-style escaping within the strings." 1: jdbc:hive2://> select 's''2' ; OK +--+ | _c0 | +--+ | s2 | +--+ 1 row selected (0.051 seconds) 1: jdbc:hive2://> select 's\'2' ; OK +--+ | _c0 | +--+ | s'2 | +--+ IMHO the '' is not meant to be an escape-sequence, but two string literals. was (Author: mcsanady): According to https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Types#LanguageManualTypes-string "Hive uses C-style escaping within the strings." 1: jdbc:hive2://> select 's''2' ; OK +--+ | _c0 | +--+ | s2 | +--+ 1 row selected (0.051 seconds) 1: jdbc:hive2://> select 's\'2' ; OK +--+ | _c0 | +--+ | s'2 | +--+ IMHO the '' is not meant to be an escape-sequence, but two string literals. > Escape apostrophe not work properly > --- > > Key: HIVE-10701 > URL: https://issues.apache.org/jira/browse/HIVE-10701 > Project: Hive > Issue Type: Bug > Components: Hive >Affects Versions: 0.12.0, 0.13.0, 0.14.0 >Reporter: Tracy Y >Assignee: Miklos Csanady >Priority: Minor > > SELECT 'S''2' FROM table return S2 instead of S'2 > The apostrophe suppose to be escaped by the single quote in front. > Thanks. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Comment Edited] (HIVE-10701) Escape apostrophe not work properly
[ https://issues.apache.org/jira/browse/HIVE-10701?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15506651#comment-15506651 ] Miklos Csanady edited comment on HIVE-10701 at 9/20/16 2:14 PM: According to https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Types#LanguageManualTypes-string "Hive uses C-style escaping within the strings." {noformat} 1: jdbc:hive2://> select 's''2' ; OK +--+ | _c0 | +--+ | s2 | +--+ 1 row selected (0.051 seconds) 1: jdbc:hive2://> select 's\'2' ; OK +--+ | _c0 | +--+ | s'2 | +--+ {noformat} IMHO the '' is not meant to be an escape-sequence, but two string literals. was (Author: mcsanady): According to https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Types#LanguageManualTypes-string "Hive uses C-style escaping within the strings." 1: jdbc:hive2://> select 's''2' ; OK +--+ | _c0 | +--+ | s2 | +--+ 1 row selected (0.051 seconds) 1: jdbc:hive2://> select 's\'2' ; OK +--+ | _c0 | +--+ | s'2 | +--+ IMHO the '' is not meant to be an escape-sequence, but two string literals. > Escape apostrophe not work properly > --- > > Key: HIVE-10701 > URL: https://issues.apache.org/jira/browse/HIVE-10701 > Project: Hive > Issue Type: Bug > Components: Hive >Affects Versions: 0.12.0, 0.13.0, 0.14.0 >Reporter: Tracy Y >Assignee: Miklos Csanady >Priority: Minor > > SELECT 'S''2' FROM table return S2 instead of S'2 > The apostrophe suppose to be escaped by the single quote in front. > Thanks. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-10701) Escape apostrophe not work properly
[ https://issues.apache.org/jira/browse/HIVE-10701?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15506651#comment-15506651 ] Miklos Csanady commented on HIVE-10701: --- According to https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Types#LanguageManualTypes-string "Hive uses C-style escaping within the strings." 1: jdbc:hive2://> select 's''2' ; OK +--+ | _c0 | +--+ | s2 | +--+ 1 row selected (0.051 seconds) 1: jdbc:hive2://> select 's\'2' ; OK +--+ | _c0 | +--+ | s'2 | +--+ IMHO the '' is not meant to be an escape-sequence, but two string literals. > Escape apostrophe not work properly > --- > > Key: HIVE-10701 > URL: https://issues.apache.org/jira/browse/HIVE-10701 > Project: Hive > Issue Type: Bug > Components: Hive >Affects Versions: 0.12.0, 0.13.0, 0.14.0 >Reporter: Tracy Y >Priority: Minor > > SELECT 'S''2' FROM table return S2 instead of S'2 > The apostrophe suppose to be escaped by the single quote in front. > Thanks. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Assigned] (HIVE-10701) Escape apostrophe not work properly
[ https://issues.apache.org/jira/browse/HIVE-10701?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Miklos Csanady reassigned HIVE-10701: - Assignee: Miklos Csanady > Escape apostrophe not work properly > --- > > Key: HIVE-10701 > URL: https://issues.apache.org/jira/browse/HIVE-10701 > Project: Hive > Issue Type: Bug > Components: Hive >Affects Versions: 0.12.0, 0.13.0, 0.14.0 >Reporter: Tracy Y >Assignee: Miklos Csanady >Priority: Minor > > SELECT 'S''2' FROM table return S2 instead of S'2 > The apostrophe suppose to be escaped by the single quote in front. > Thanks. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-14049) Password prompt in Beeline is continuously printed
[ https://issues.apache.org/jira/browse/HIVE-14049?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15506549#comment-15506549 ] Miklos Csanady commented on HIVE-14049: --- Can you give some details to reproduce the error? On my mac it works as expected: Beeline version 2.2.0-SNAPSHOT by Apache Hive beeline> !connect jdbc:hive2:// Connecting to jdbc:hive2:// Enter username for jdbc:hive2://: hive Enter password for jdbc:hive2://: The second readLine call is responsible for the password input. It replaces the output to the console to * as you see. > Password prompt in Beeline is continuously printed > -- > > Key: HIVE-14049 > URL: https://issues.apache.org/jira/browse/HIVE-14049 > Project: Hive > Issue Type: Bug > Components: Beeline >Affects Versions: 2.0.1 >Reporter: Abdullah Yousufi > > I'm experiencing this issue with a Mac, which was not occurring until > recently. > {code} > Beeline version 2.2.0-SNAPSHOT by Apache Hive > beeline> !connect jdbc:hive2://localhost:1 > Connecting to jdbc:hive2://localhost:1 > Enter username for jdbc:hive2://localhost:1: hive > Enter password for jdbc:hive2://localhost:1: > Enter password for jdbc:hive2://localhost:1: > Enter password for jdbc:hive2://localhost:1: > ... > {code} > The 'Enter password for jdbc:hive2://localhost:1:' line continues to > print until enter is hit. From looking at the code in Commands.java (lines > 1413-1420), it's not quite clear why this happens on the second call to > readLine()) : > {code} > if (username == null) { > username = beeLine.getConsoleReader().readLine("Enter username for " + url > + ": "); > } > props.setProperty("user", username); > if (password == null) { > password = beeLine.getConsoleReader().readLine("Enter password for " + url > + ": ", > new Character('*')); > } > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Assigned] (HIVE-14252) Sum on Decimal rounding provides incorrect result
[ https://issues.apache.org/jira/browse/HIVE-14252?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Miklos Csanady reassigned HIVE-14252: - Assignee: (was: Miklos Csanady) > Sum on Decimal rounding provides incorrect result > - > > Key: HIVE-14252 > URL: https://issues.apache.org/jira/browse/HIVE-14252 > Project: Hive > Issue Type: Bug >Reporter: Varun Gullipalli > Attachments: test data.txt > > > hive> select sum(round(amt, 2)), sum(round(txn_amt, 2)) from table1 where DT > ='20160517' > union all > select sum(round(amt,2)), sum(round(txn_amt,2)) from table2 > where DT ='20160517' > 99773.577 77408.35 > 3336.16996 2582.35013 -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Assigned] (HIVE-14252) Sum on Decimal rounding provides incorrect result
[ https://issues.apache.org/jira/browse/HIVE-14252?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Miklos Csanady reassigned HIVE-14252: - Assignee: Miklos Csanady > Sum on Decimal rounding provides incorrect result > - > > Key: HIVE-14252 > URL: https://issues.apache.org/jira/browse/HIVE-14252 > Project: Hive > Issue Type: Bug >Reporter: Varun Gullipalli >Assignee: Miklos Csanady > Attachments: test data.txt > > > hive> select sum(round(amt, 2)), sum(round(txn_amt, 2)) from table1 where DT > ='20160517' > union all > select sum(round(amt,2)), sum(round(txn_amt,2)) from table2 > where DT ='20160517' > 99773.577 77408.35 > 3336.16996 2582.35013 -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HIVE-14525) beeline still writing log data to stdout as of version 2.1.0
[ https://issues.apache.org/jira/browse/HIVE-14525?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Miklos Csanady updated HIVE-14525: -- Status: Open (was: Patch Available) Will not pass existing tests with verifyCMD method. > beeline still writing log data to stdout as of version 2.1.0 > > > Key: HIVE-14525 > URL: https://issues.apache.org/jira/browse/HIVE-14525 > Project: Hive > Issue Type: Bug > Components: Beeline >Affects Versions: 2.1.0, 2.2.0 >Reporter: stephen sprague >Assignee: Miklos Csanady > Labels: beeline > Attachments: HIVE-14525.1.patch, HIVE-14525.2.patch, > HIVE-14525.3.patch, HIVE-14525.4.patch, HIVE-14525.patch > > > simple test. note that i'm looking to get a tsv file back. > {code} > $ beeline -u dwrdevnn1 --showHeader=false --outputformat=tsv22>stderr > > select count(*) > > from default.dual; > > SQL > {code} > instead i get this in stdout: > {code} > $ cat stdout > 0: jdbc:hive2://dwrdevnn1.sv2.trulia.com:1000> select count(*) > . . . . . . . . . . . . . . . . . . . . . . .> from default.dual; > 0 > 0: jdbc:hive2://dwrdevnn1.sv2.trulia.com:1000> > {code} > i should only get one row which is the *result* of the query (which is 0) - > not the ovthe loggy kind of lines you see above. that stuff goes to stderr my > friends. > also i refer to this ticket b/c the last comment suggested so - its close but > not exactly the same. > https://issues.apache.org/jira/browse/HIVE-14183 -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HIVE-14525) beeline still writing log data to stdout as of version 2.1.0
[ https://issues.apache.org/jira/browse/HIVE-14525?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Miklos Csanady updated HIVE-14525: -- Attachment: HIVE-14525.4.patch Missing spaces. See review. > beeline still writing log data to stdout as of version 2.1.0 > > > Key: HIVE-14525 > URL: https://issues.apache.org/jira/browse/HIVE-14525 > Project: Hive > Issue Type: Bug > Components: Beeline >Affects Versions: 2.1.0, 2.2.0 >Reporter: stephen sprague >Assignee: Miklos Csanady > Labels: beeline > Attachments: HIVE-14525.1.patch, HIVE-14525.2.patch, > HIVE-14525.3.patch, HIVE-14525.4.patch, HIVE-14525.patch > > > simple test. note that i'm looking to get a tsv file back. > {code} > $ beeline -u dwrdevnn1 --showHeader=false --outputformat=tsv22>stderr > > select count(*) > > from default.dual; > > SQL > {code} > instead i get this in stdout: > {code} > $ cat stdout > 0: jdbc:hive2://dwrdevnn1.sv2.trulia.com:1000> select count(*) > . . . . . . . . . . . . . . . . . . . . . . .> from default.dual; > 0 > 0: jdbc:hive2://dwrdevnn1.sv2.trulia.com:1000> > {code} > i should only get one row which is the *result* of the query (which is 0) - > not the ovthe loggy kind of lines you see above. that stuff goes to stderr my > friends. > also i refer to this ticket b/c the last comment suggested so - its close but > not exactly the same. > https://issues.apache.org/jira/browse/HIVE-14183 -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HIVE-14525) beeline still writing log data to stdout as of version 2.1.0
[ https://issues.apache.org/jira/browse/HIVE-14525?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Miklos Csanady updated HIVE-14525: -- Attachment: HIVE-14525.3.patch Whitespace fixes > beeline still writing log data to stdout as of version 2.1.0 > > > Key: HIVE-14525 > URL: https://issues.apache.org/jira/browse/HIVE-14525 > Project: Hive > Issue Type: Bug > Components: Beeline >Affects Versions: 2.1.0, 2.2.0 >Reporter: stephen sprague >Assignee: Miklos Csanady > Labels: beeline > Attachments: HIVE-14525.1.patch, HIVE-14525.2.patch, > HIVE-14525.3.patch, HIVE-14525.patch > > > simple test. note that i'm looking to get a tsv file back. > {code} > $ beeline -u dwrdevnn1 --showHeader=false --outputformat=tsv22>stderr > > select count(*) > > from default.dual; > > SQL > {code} > instead i get this in stdout: > {code} > $ cat stdout > 0: jdbc:hive2://dwrdevnn1.sv2.trulia.com:1000> select count(*) > . . . . . . . . . . . . . . . . . . . . . . .> from default.dual; > 0 > 0: jdbc:hive2://dwrdevnn1.sv2.trulia.com:1000> > {code} > i should only get one row which is the *result* of the query (which is 0) - > not the ovthe loggy kind of lines you see above. that stuff goes to stderr my > friends. > also i refer to this ticket b/c the last comment suggested so - its close but > not exactly the same. > https://issues.apache.org/jira/browse/HIVE-14183 -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HIVE-14525) beeline still writing log data to stdout as of version 2.1.0
[ https://issues.apache.org/jira/browse/HIVE-14525?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Miklos Csanady updated HIVE-14525: -- Labels: beeline (was: ) Affects Version/s: 2.2.0 Tags: Beeline Status: Patch Available (was: Open) HIVE-14525 > beeline still writing log data to stdout as of version 2.1.0 > > > Key: HIVE-14525 > URL: https://issues.apache.org/jira/browse/HIVE-14525 > Project: Hive > Issue Type: Bug > Components: Beeline >Affects Versions: 2.1.0, 2.2.0 >Reporter: stephen sprague >Assignee: Miklos Csanady > Labels: beeline > Attachments: HIVE-14525.1.patch, HIVE-14525.2.patch, HIVE-14525.patch > > > simple test. note that i'm looking to get a tsv file back. > {code} > $ beeline -u dwrdevnn1 --showHeader=false --outputformat=tsv22>stderr > > select count(*) > > from default.dual; > > SQL > {code} > instead i get this in stdout: > {code} > $ cat stdout > 0: jdbc:hive2://dwrdevnn1.sv2.trulia.com:1000> select count(*) > . . . . . . . . . . . . . . . . . . . . . . .> from default.dual; > 0 > 0: jdbc:hive2://dwrdevnn1.sv2.trulia.com:1000> > {code} > i should only get one row which is the *result* of the query (which is 0) - > not the ovthe loggy kind of lines you see above. that stuff goes to stderr my > friends. > also i refer to this ticket b/c the last comment suggested so - its close but > not exactly the same. > https://issues.apache.org/jira/browse/HIVE-14183 -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HIVE-14525) beeline still writing log data to stdout as of version 2.1.0
[ https://issues.apache.org/jira/browse/HIVE-14525?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Miklos Csanady updated HIVE-14525: -- Attachment: HIVE-14525.2.patch https://reviews.apache.org/r/51287/ > beeline still writing log data to stdout as of version 2.1.0 > > > Key: HIVE-14525 > URL: https://issues.apache.org/jira/browse/HIVE-14525 > Project: Hive > Issue Type: Bug > Components: Beeline >Affects Versions: 2.1.0 >Reporter: stephen sprague >Assignee: Miklos Csanady > Attachments: HIVE-14525.1.patch, HIVE-14525.2.patch, HIVE-14525.patch > > > simple test. note that i'm looking to get a tsv file back. > {code} > $ beeline -u dwrdevnn1 --showHeader=false --outputformat=tsv22>stderr > > select count(*) > > from default.dual; > > SQL > {code} > instead i get this in stdout: > {code} > $ cat stdout > 0: jdbc:hive2://dwrdevnn1.sv2.trulia.com:1000> select count(*) > . . . . . . . . . . . . . . . . . . . . . . .> from default.dual; > 0 > 0: jdbc:hive2://dwrdevnn1.sv2.trulia.com:1000> > {code} > i should only get one row which is the *result* of the query (which is 0) - > not the ovthe loggy kind of lines you see above. that stuff goes to stderr my > friends. > also i refer to this ticket b/c the last comment suggested so - its close but > not exactly the same. > https://issues.apache.org/jira/browse/HIVE-14183 -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HIVE-14525) beeline still writing log data to stdout as of version 2.1.0
[ https://issues.apache.org/jira/browse/HIVE-14525?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Miklos Csanady updated HIVE-14525: -- Attachment: HIVE-14525.1.patch > beeline still writing log data to stdout as of version 2.1.0 > > > Key: HIVE-14525 > URL: https://issues.apache.org/jira/browse/HIVE-14525 > Project: Hive > Issue Type: Bug > Components: Beeline >Affects Versions: 2.1.0 >Reporter: stephen sprague >Assignee: Miklos Csanady > Attachments: HIVE-14525.1.patch, HIVE-14525.patch > > > simple test. note that i'm looking to get a tsv file back. > {code} > $ beeline -u dwrdevnn1 --showHeader=false --outputformat=tsv22>stderr > > select count(*) > > from default.dual; > > SQL > {code} > instead i get this in stdout: > {code} > $ cat stdout > 0: jdbc:hive2://dwrdevnn1.sv2.trulia.com:1000> select count(*) > . . . . . . . . . . . . . . . . . . . . . . .> from default.dual; > 0 > 0: jdbc:hive2://dwrdevnn1.sv2.trulia.com:1000> > {code} > i should only get one row which is the *result* of the query (which is 0) - > not the ovthe loggy kind of lines you see above. that stuff goes to stderr my > friends. > also i refer to this ticket b/c the last comment suggested so - its close but > not exactly the same. > https://issues.apache.org/jira/browse/HIVE-14183 -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-14525) beeline still writing log data to stdout as of version 2.1.0
[ https://issues.apache.org/jira/browse/HIVE-14525?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15430757#comment-15430757 ] Miklos Csanady commented on HIVE-14525: --- The ConsoleReader class should not echo back to stdout when consuming a line with readLine method. If ! isSlilent we echo it back with .info() method with prompt. Please review my patch. > beeline still writing log data to stdout as of version 2.1.0 > > > Key: HIVE-14525 > URL: https://issues.apache.org/jira/browse/HIVE-14525 > Project: Hive > Issue Type: Bug > Components: Beeline >Affects Versions: 2.1.0 >Reporter: stephen sprague >Assignee: Miklos Csanady > Attachments: HIVE-14525.patch > > > simple test. note that i'm looking to get a tsv file back. > {code} > $ beeline -u dwrdevnn1 --showHeader=false --outputformat=tsv22>stderr > > select count(*) > > from default.dual; > > SQL > {code} > instead i get this in stdout: > {code} > $ cat stdout > 0: jdbc:hive2://dwrdevnn1.sv2.trulia.com:1000> select count(*) > . . . . . . . . . . . . . . . . . . . . . . .> from default.dual; > 0 > 0: jdbc:hive2://dwrdevnn1.sv2.trulia.com:1000> > {code} > i should only get one row which is the *result* of the query (which is 0) - > not the ovthe loggy kind of lines you see above. that stuff goes to stderr my > friends. > also i refer to this ticket b/c the last comment suggested so - its close but > not exactly the same. > https://issues.apache.org/jira/browse/HIVE-14183 -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HIVE-14525) beeline still writing log data to stdout as of version 2.1.0
[ https://issues.apache.org/jira/browse/HIVE-14525?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Miklos Csanady updated HIVE-14525: -- Attachment: HIVE-14525.patch > beeline still writing log data to stdout as of version 2.1.0 > > > Key: HIVE-14525 > URL: https://issues.apache.org/jira/browse/HIVE-14525 > Project: Hive > Issue Type: Bug > Components: Beeline >Affects Versions: 2.1.0 >Reporter: stephen sprague >Assignee: Miklos Csanady > Attachments: HIVE-14525.patch > > > simple test. note that i'm looking to get a tsv file back. > {code} > $ beeline -u dwrdevnn1 --showHeader=false --outputformat=tsv22>stderr > > select count(*) > > from default.dual; > > SQL > {code} > instead i get this in stdout: > {code} > $ cat stdout > 0: jdbc:hive2://dwrdevnn1.sv2.trulia.com:1000> select count(*) > . . . . . . . . . . . . . . . . . . . . . . .> from default.dual; > 0 > 0: jdbc:hive2://dwrdevnn1.sv2.trulia.com:1000> > {code} > i should only get one row which is the *result* of the query (which is 0) - > not the ovthe loggy kind of lines you see above. that stuff goes to stderr my > friends. > also i refer to this ticket b/c the last comment suggested so - its close but > not exactly the same. > https://issues.apache.org/jira/browse/HIVE-14183 -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Assigned] (HIVE-14525) beeline still writing log data to stdout as of version 2.1.0
[ https://issues.apache.org/jira/browse/HIVE-14525?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Miklos Csanady reassigned HIVE-14525: - Assignee: Miklos Csanady > beeline still writing log data to stdout as of version 2.1.0 > > > Key: HIVE-14525 > URL: https://issues.apache.org/jira/browse/HIVE-14525 > Project: Hive > Issue Type: Bug > Components: Beeline >Affects Versions: 2.1.0 >Reporter: stephen sprague >Assignee: Miklos Csanady > > simple test. note that i'm looking to get a tsv file back. > {code} > $ beeline -u dwrdevnn1 --showHeader=false --outputformat=tsv22>stderr > > select count(*) > > from default.dual; > > SQL > {code} > instead i get this in stdout: > {code} > $ cat stdout > 0: jdbc:hive2://dwrdevnn1.sv2.trulia.com:1000> select count(*) > . . . . . . . . . . . . . . . . . . . . . . .> from default.dual; > 0 > 0: jdbc:hive2://dwrdevnn1.sv2.trulia.com:1000> > {code} > i should only get one row which is the *result* of the query (which is 0) - > not the ovthe loggy kind of lines you see above. that stuff goes to stderr my > friends. > also i refer to this ticket b/c the last comment suggested so - its close but > not exactly the same. > https://issues.apache.org/jira/browse/HIVE-14183 -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-14525) beeline still writing log data to stdout as of version 2.1.0
[ https://issues.apache.org/jira/browse/HIVE-14525?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15420959#comment-15420959 ] Miklos Csanady commented on HIVE-14525: --- The prompt and other debug info is echoed to stdout only if --silent=true is not set. These are supressed if on commandline -f file AND --silent=true are present. Beeline cannot detect command line output redirection. > beeline still writing log data to stdout as of version 2.1.0 > > > Key: HIVE-14525 > URL: https://issues.apache.org/jira/browse/HIVE-14525 > Project: Hive > Issue Type: Bug > Components: Beeline >Affects Versions: 2.1.0 >Reporter: stephen sprague > > simple test. note that i'm looking to get a tsv file back. > {code} > $ beeline -u dwrdevnn1 --showHeader=false --outputformat=tsv22>stderr > > select count(*) > > from default.dual; > > SQL > {code} > instead i get this in stdout: > {code} > $ cat stdout > 0: jdbc:hive2://dwrdevnn1.sv2.trulia.com:1000> select count(*) > . . . . . . . . . . . . . . . . . . . . . . .> from default.dual; > 0 > 0: jdbc:hive2://dwrdevnn1.sv2.trulia.com:1000> > {code} > i should only get one row which is the *result* of the query (which is 0) - > not the ovthe loggy kind of lines you see above. that stuff goes to stderr my > friends. > also i refer to this ticket b/c the last comment suggested so - its close but > not exactly the same. > https://issues.apache.org/jira/browse/HIVE-14183 -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-14525) beeline still writing log data to stdout as of version 2.1.0
[ https://issues.apache.org/jira/browse/HIVE-14525?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15419956#comment-15419956 ] Miklos Csanady commented on HIVE-14525: --- The "loggy kind of lines" contains the query, which is the subject of the other issue. > beeline still writing log data to stdout as of version 2.1.0 > > > Key: HIVE-14525 > URL: https://issues.apache.org/jira/browse/HIVE-14525 > Project: Hive > Issue Type: Bug > Components: Beeline >Affects Versions: 2.1.0 >Reporter: stephen sprague > > simple test. note that i'm looking to get a tsv file back. > {code} > $ beeline -u dwrdevnn1 --showHeader=false --outputformat=tsv22>stderr > > select count(*) > > from default.dual; > > SQL > {code} > instead i get this in stdout: > {code} > $ cat stdout > 0: jdbc:hive2://dwrdevnn1.sv2.trulia.com:1000> select count(*) > . . . . . . . . . . . . . . . . . . . . . . .> from default.dual; > 0 > 0: jdbc:hive2://dwrdevnn1.sv2.trulia.com:1000> > {code} > i should only get one row which is the *result* of the query (which is 0) - > not the ovthe loggy kind of lines you see above. that stuff goes to stderr my > friends. > also i refer to this ticket b/c the last comment suggested so - its close but > not exactly the same. > https://issues.apache.org/jira/browse/HIVE-14183 -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-14345) Beeline result table has erroneous characters
[ https://issues.apache.org/jira/browse/HIVE-14345?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15419922#comment-15419922 ] Miklos Csanady commented on HIVE-14345: --- None of the failures involve the beeline component, so they are not relevant to this patch. > Beeline result table has erroneous characters > -- > > Key: HIVE-14345 > URL: https://issues.apache.org/jira/browse/HIVE-14345 > Project: Hive > Issue Type: Bug > Components: Beeline >Affects Versions: 1.1.0, 2.2.0 >Reporter: Jeremy Beard >Assignee: Miklos Csanady >Priority: Minor > Attachments: HIVE-14345.3.patch, HIVE-14345.4.patch, > HIVE-14345.5.patch, HIVE-14345.patch > > > Beeline returns query results with erroneous characters. For example: > {code} > 0: jdbc:hive2://:1/def> select 10; > +--+--+ > | _c0 | > +--+--+ > | 10 | > +--+--+ > 1 row selected (3.207 seconds) > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HIVE-14345) Beeline result table has erroneous characters
[ https://issues.apache.org/jira/browse/HIVE-14345?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Miklos Csanady updated HIVE-14345: -- Attachment: HIVE-14345.5.patch fixing formatting issue > Beeline result table has erroneous characters > -- > > Key: HIVE-14345 > URL: https://issues.apache.org/jira/browse/HIVE-14345 > Project: Hive > Issue Type: Bug > Components: Beeline >Affects Versions: 1.1.0, 2.2.0 >Reporter: Jeremy Beard >Assignee: Miklos Csanady >Priority: Minor > Attachments: HIVE-14345.3.patch, HIVE-14345.4.patch, > HIVE-14345.5.patch, HIVE-14345.patch > > > Beeline returns query results with erroneous characters. For example: > {code} > 0: jdbc:hive2://:1/def> select 10; > +--+--+ > | _c0 | > +--+--+ > | 10 | > +--+--+ > 1 row selected (3.207 seconds) > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HIVE-14345) Beeline result table has erroneous characters
[ https://issues.apache.org/jira/browse/HIVE-14345?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Miklos Csanady updated HIVE-14345: -- Attachment: HIVE-14345.4.patch Formatting fixes > Beeline result table has erroneous characters > -- > > Key: HIVE-14345 > URL: https://issues.apache.org/jira/browse/HIVE-14345 > Project: Hive > Issue Type: Bug > Components: Beeline >Affects Versions: 1.1.0, 2.2.0 >Reporter: Jeremy Beard >Assignee: Miklos Csanady >Priority: Minor > Attachments: HIVE-14345.3.patch, HIVE-14345.4.patch, HIVE-14345.patch > > > Beeline returns query results with erroneous characters. For example: > {code} > 0: jdbc:hive2://:1/def> select 10; > +--+--+ > | _c0 | > +--+--+ > | 10 | > +--+--+ > 1 row selected (3.207 seconds) > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HIVE-14345) Beeline result table has erroneous characters
[ https://issues.apache.org/jira/browse/HIVE-14345?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Miklos Csanady updated HIVE-14345: -- Attachment: HIVE-14345.3.patch Checkstyle fixes > Beeline result table has erroneous characters > -- > > Key: HIVE-14345 > URL: https://issues.apache.org/jira/browse/HIVE-14345 > Project: Hive > Issue Type: Bug > Components: Beeline >Affects Versions: 1.1.0, 2.2.0 >Reporter: Jeremy Beard >Assignee: Miklos Csanady >Priority: Minor > Attachments: HIVE-14345.3.patch, HIVE-14345.patch > > > Beeline returns query results with erroneous characters. For example: > {code} > 0: jdbc:hive2://:1/def> select 10; > +--+--+ > | _c0 | > +--+--+ > | 10 | > +--+--+ > 1 row selected (3.207 seconds) > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HIVE-14345) Beeline result table has erroneous characters
[ https://issues.apache.org/jira/browse/HIVE-14345?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Miklos Csanady updated HIVE-14345: -- Hadoop Flags: Reviewed Affects Version/s: 2.2.0 Status: Patch Available (was: Open) > Beeline result table has erroneous characters > -- > > Key: HIVE-14345 > URL: https://issues.apache.org/jira/browse/HIVE-14345 > Project: Hive > Issue Type: Bug > Components: Beeline >Affects Versions: 1.1.0, 2.2.0 >Reporter: Jeremy Beard >Assignee: Miklos Csanady >Priority: Minor > Attachments: HIVE-14345.patch > > > Beeline returns query results with erroneous characters. For example: > {code} > 0: jdbc:hive2://:1/def> select 10; > +--+--+ > | _c0 | > +--+--+ > | 10 | > +--+--+ > 1 row selected (3.207 seconds) > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HIVE-14345) Beeline result table has erroneous characters
[ https://issues.apache.org/jira/browse/HIVE-14345?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Miklos Csanady updated HIVE-14345: -- Attachment: HIVE-14345.patch > Beeline result table has erroneous characters > -- > > Key: HIVE-14345 > URL: https://issues.apache.org/jira/browse/HIVE-14345 > Project: Hive > Issue Type: Bug > Components: Beeline >Affects Versions: 1.1.0 >Reporter: Jeremy Beard >Assignee: Miklos Csanady >Priority: Minor > Attachments: HIVE-14345.patch > > > Beeline returns query results with erroneous characters. For example: > {code} > 0: jdbc:hive2://:1/def> select 10; > +--+--+ > | _c0 | > +--+--+ > | 10 | > +--+--+ > 1 row selected (3.207 seconds) > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HIVE-14345) Beeline result table has erroneous characters
[ https://issues.apache.org/jira/browse/HIVE-14345?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Miklos Csanady updated HIVE-14345: -- Attachment: (was: HIVE-14345-2.patch) > Beeline result table has erroneous characters > -- > > Key: HIVE-14345 > URL: https://issues.apache.org/jira/browse/HIVE-14345 > Project: Hive > Issue Type: Bug > Components: Beeline >Affects Versions: 1.1.0 >Reporter: Jeremy Beard >Assignee: Miklos Csanady >Priority: Minor > > Beeline returns query results with erroneous characters. For example: > {code} > 0: jdbc:hive2://:1/def> select 10; > +--+--+ > | _c0 | > +--+--+ > | 10 | > +--+--+ > 1 row selected (3.207 seconds) > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HIVE-14345) Beeline result table has erroneous characters
[ https://issues.apache.org/jira/browse/HIVE-14345?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Miklos Csanady updated HIVE-14345: -- Attachment: (was: HIVE-14345.patch) > Beeline result table has erroneous characters > -- > > Key: HIVE-14345 > URL: https://issues.apache.org/jira/browse/HIVE-14345 > Project: Hive > Issue Type: Bug > Components: Beeline >Affects Versions: 1.1.0 >Reporter: Jeremy Beard >Assignee: Miklos Csanady >Priority: Minor > Attachments: HIVE-14345-2.patch > > > Beeline returns query results with erroneous characters. For example: > {code} > 0: jdbc:hive2://:1/def> select 10; > +--+--+ > | _c0 | > +--+--+ > | 10 | > +--+--+ > 1 row selected (3.207 seconds) > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HIVE-14345) Beeline result table has erroneous characters
[ https://issues.apache.org/jira/browse/HIVE-14345?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Miklos Csanady updated HIVE-14345: -- Attachment: HIVE-14345-2.patch > Beeline result table has erroneous characters > -- > > Key: HIVE-14345 > URL: https://issues.apache.org/jira/browse/HIVE-14345 > Project: Hive > Issue Type: Bug > Components: Beeline >Affects Versions: 1.1.0 >Reporter: Jeremy Beard >Assignee: Miklos Csanady >Priority: Minor > Attachments: HIVE-14345-2.patch, HIVE-14345.patch > > > Beeline returns query results with erroneous characters. For example: > {code} > 0: jdbc:hive2://:1/def> select 10; > +--+--+ > | _c0 | > +--+--+ > | 10 | > +--+--+ > 1 row selected (3.207 seconds) > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HIVE-14345) Beeline result table has erroneous characters
[ https://issues.apache.org/jira/browse/HIVE-14345?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Miklos Csanady updated HIVE-14345: -- Attachment: HIVE-14345.patch Fixes TableOuputFormat bug. > Beeline result table has erroneous characters > -- > > Key: HIVE-14345 > URL: https://issues.apache.org/jira/browse/HIVE-14345 > Project: Hive > Issue Type: Bug > Components: Beeline >Affects Versions: 1.1.0 >Reporter: Jeremy Beard >Assignee: Miklos Csanady >Priority: Minor > Attachments: HIVE-14345.patch > > > Beeline returns query results with erroneous characters. For example: > {code} > 0: jdbc:hive2://:1/def> select 10; > +--+--+ > | _c0 | > +--+--+ > | 10 | > +--+--+ > 1 row selected (3.207 seconds) > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Assigned] (HIVE-14345) Beeline result table has erroneous characters
[ https://issues.apache.org/jira/browse/HIVE-14345?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Miklos Csanady reassigned HIVE-14345: - Assignee: Miklos Csanady > Beeline result table has erroneous characters > -- > > Key: HIVE-14345 > URL: https://issues.apache.org/jira/browse/HIVE-14345 > Project: Hive > Issue Type: Bug > Components: Beeline >Affects Versions: 1.1.0 >Reporter: Jeremy Beard >Assignee: Miklos Csanady >Priority: Minor > > Beeline returns query results with erroneous characters. For example: > {code} > 0: jdbc:hive2://:1/def> select 10; > +--+--+ > | _c0 | > +--+--+ > | 10 | > +--+--+ > 1 row selected (3.207 seconds) > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)