[
https://issues.apache.org/jira/browse/HIVE-22550?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17267843#comment-17267843
]
Ayush Saxena commented on HIVE-22550:
-------------------------------------
Thanx [~kgyrtkirk] I tried on beeline the said command gives me the same output
with/without patch
Without fix :
{code:java}
0: jdbc:hive2://localhost:10000> select '<b>asd</b>' ;
INFO : Compiling
command(queryId=ayushsaxena_20210119165155_5f978f42-b27b-4c31-b284-72cc493fea69):
select '<b>asd</b>'
INFO : Semantic Analysis Completed (retrial = false)
INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:_c0,
type:string, comment:null)], properties:null)
INFO : Completed compiling
command(queryId=ayushsaxena_20210119165155_5f978f42-b27b-4c31-b284-72cc493fea69);
Time taken: 0.036 seconds
INFO : Concurrency mode is disabled, not creating a lock manager
INFO : Executing
command(queryId=ayushsaxena_20210119165155_5f978f42-b27b-4c31-b284-72cc493fea69):
select '<b>asd</b>'
INFO : Completed executing
command(queryId=ayushsaxena_20210119165155_5f978f42-b27b-4c31-b284-72cc493fea69);
Time taken: 0.002 seconds
+-------------+
| _c0 |
+-------------+
| <b>asd</b> |
+-------------+
1 row selected (0.054 seconds)
0: jdbc:hive2://localhost:10000>
{code}
With FIx :
{code:java}
ayushsaxena@ayushsaxena-MBP16 apache-hive-4.0.0-SNAPSHOT-bin % bin/beeline -n
ayushsaxena -u jdbc:hive2://localhost:10000
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in
[jar:file:/Users/ayushsaxena/code/hive-os/hive/packaging/target/apache-hive-4.0.0-SNAPSHOT-bin/apache-hive-4.0.0-SNAPSHOT-bin/lib/log4j-slf4j-impl-2.12.1.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in
[jar:file:/Users/ayushsaxena/code/hadoop-code/osCode/hadoop-3.2.2/share/hadoop/common/lib/slf4j-log4j12-1.7.25.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:10000
Connected to: Apache Hive (version 4.0.0-SNAPSHOT)
Driver: Hive JDBC (version 4.0.0-SNAPSHOT)
Transaction isolation: TRANSACTION_REPEATABLE_READ
Beeline version 4.0.0-SNAPSHOT by Apache Hive
0: jdbc:hive2://localhost:10000> select '<b>asd</b>' ;
INFO : Compiling
command(queryId=ayushsaxena_20210119170057_7fe1fb73-aee0-40cd-83a8-4ddac4c2d69d):
select '<b>asd</b>'
INFO : Semantic Analysis Completed (retrial = false)
INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:_c0,
type:string, comment:null)], properties:null)
INFO : Completed compiling
command(queryId=ayushsaxena_20210119170057_7fe1fb73-aee0-40cd-83a8-4ddac4c2d69d);
Time taken: 0.083 seconds
INFO : Concurrency mode is disabled, not creating a lock manager
INFO : Executing
command(queryId=ayushsaxena_20210119170057_7fe1fb73-aee0-40cd-83a8-4ddac4c2d69d):
select '<b>asd</b>'
INFO : Completed executing
command(queryId=ayushsaxena_20210119170057_7fe1fb73-aee0-40cd-83a8-4ddac4c2d69d);
Time taken: 0.0 seconds
+-------------+
| _c0 |
+-------------+
| <b>asd</b> |
+-------------+
1 row selected (0.198 seconds)
0: jdbc:hive2://localhost:10000>
{code}
> Result of hive.query.string in job xml contains encoded string
> ---------------------------------------------------------------
>
> Key: HIVE-22550
> URL: https://issues.apache.org/jira/browse/HIVE-22550
> Project: Hive
> Issue Type: Bug
> Affects Versions: 3.1.0, 3.1.1
> Reporter: zhangbutao
> Assignee: zhangbutao
> Priority: Major
> Labels: pull-request-available
> Attachments: HIVE-branch-3.1.patch, job xml.JPG
>
> Time Spent: 0.5h
> Remaining Estimate: 0h
>
> repo:
> Query : *insert into test values(1)*
> job xml will be display *insert+into+test+values%281%29*
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
