On this page

    Categories: Directory

    IMAXDIR

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

    Syntax

    IMAXDIR(‘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 IMAXDIR to query the data that is in the 2021 subdirectory. The result is the same as if you used the MAXDIR function.

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

    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 = IMAXDIR('dfs','/tmp/querylogs')
    -- D