...
...
Expand |
---|
|
Result of the query select id, value, comment from test_table No Format |
---|
<resultset>
<result>
<id>1</id>
<value>Value1</value>
<comment>Test comment 1</comment>
</result>
<result>
<id>2</id>
<value>Value2</value>
<comment>Test comment 2</comment>
</result>
<result>
<id>3</id>
<value>Value3</value>
<comment>Test comment 3</comment>
</result>
</resultset> |
|
json
(Hive 4.0) The result is displayed in JSON format where each row is a "result" element in the JSON array "resultset".
Expand |
---|
|
Result of the query select `String`, `Int`, `Decimal`, `Bool`, `Null`, `Binary` from test_table No Format |
---|
{"resultset":[{"String":"aaa","Int":1,"Decimal":3.14,"Bool":true,"Null":null,"Binary":"SGVsbG8sIFdvcmxkIQ"},{"String":"bbb","Int":2,"Decimal":2.718,"Bool":false,"Null":null,"Binary":"RWFzdGVyCgllZ2cu"}]} |
|
jsonfile
(Hive 4.0) The result is displayed in JSON format where each row is a distinct JSON object. This matches the expected format for a table created as JSONFILE format.
Expand |
---|
|
Result of the query select `String`, `Int`, `Decimal`, `Bool`, `Null`, `Binary` from test_table No Format |
---|
{"String":"aaa","Int":1,"Decimal":3.14,"Bool":true,"Null":null,"Binary":"SGVsbG8sIFdvcmxkIQ"}
{"String":"bbb","Int":2,"Decimal":2.718,"Bool":false,"Null":null,"Binary":"RWFzdGVyCgllZ2cu"} |
|
Separated-Value Output Formats
...