Versions Compared

Old Version 193

changes.mady.by.user David Mollitor

Saved on

compared with

New Version 194

changes.mady.by.user David Mollitor

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Added information for new beeline output format: JSON

...

...

Expand
titleExample

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
titleExample

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
titleExample

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

...