Skip to main content
Version: current [25.x]

Categories: Directory

IMINDIR

Returns the name of a subdirectory of a table in HDFS. The subdirectory has the name that ranks lowest in case-insensitive alphanumeric order.

Syntax​

IMINDIR('dfs', '<path_of_parent_directory>') → <name_of_subdirectory>​

  • dfs: Specifies that the table data is in an HDFS filesystem.
  • <path_of_parent_directory>: The full path of the directory in which the table data is stored.
  • <name_of_subdirectory>: The name of the subdirectory.

Examples

Example 1: Suppose that there is a directory named querylogs in the /tmp directory. In the querylogs directory, there are three subdirectories:

  • 2019
  • 2020
  • 2021

In each subdirectory, there is a CSV file that contains log data. You can use IMINDIR to query the data that is in the 2019 subdirectory. The result is the same as if you used the MAXDIR function.

SELECT * FROM dfs."/tmp/querylogs" WHERE dir0 = IMINDIR('dfs','/tmp/querylogs')
-- 2019

Example 2: Suppose that there is a directory named products in the /tmp directory. In the products directory, there are these subdirectories in this order:

  • a
  • A
  • B
  • b
  • c
  • C
  • d
  • D

In each subdirectory, there is a CSV file that contains product data.

Use dir0 to retrieve the name of a subdirectory one level below the parent directory, dir1 to retrieve the name of a subdirectory two levels below, and so on.

SELECT * FROM dfs."/tmp/querylogs" WHERE dir0 = IMINDIR('dfs','/tmp/querylogs')
-- a