File

Description

You can query a file with a specified format directly with SQL.

Syntax

  1. file_format.`file_path`

Parameters

  • file_format

    Specifies a file format for a given file path, could be TEXTFILE, ORC, PARQUET, etc.

  • file_path

    Specifies a file path with a given format.

Examples

  1. -- PARQUET file
  2. SELECT * FROM parquet.`examples/src/main/resources/users.parquet`;
  3. +------+--------------+----------------+
  4. |  name|favorite_color|favorite_numbers|
  5. +------+--------------+----------------+
  6. |Alyssa|          null|  [3, 9, 15, 20]|
  7. |   Ben|           red|              []|
  8. +------+--------------+----------------+
  10. -- ORC file
  11. SELECT * FROM orc.`examples/src/main/resources/users.orc`;
  12. +------+--------------+----------------+
  13. |  name|favorite_color|favorite_numbers|
  14. +------+--------------+----------------+
  15. |Alyssa|          null|  [3, 9, 15, 20]|
  16. |   Ben|           red|              []|
  17. +------+--------------+----------------+
  19. -- JSON file
  20. SELECT * FROM json.`examples/src/main/resources/people.json`;
  21. +----+-------+
  22. | age|   name|
  23. +----+-------+
  24. |null|Michael|
  25. |  30|   Andy|
  26. |  19| Justin|
  27. +----+-------+