Netezza Performance Server

 View Only
Expand all | Collapse all

Parse JSON String via SELECT Statement.

  • 1.  Parse JSON String via SELECT Statement.

    Posted Wed August 24, 2022 08:32 AM
    Edited by System Test Fri January 20, 2023 04:44 PM
    How would I parse the following JSON into two columns - country_code and country_name?:


    Here is the Netezza code in text format:

    WITH
    NATIONALITIES_JSON AS (
    SELECT '
    [
    [ "AG", "Argentinian" ], [ "AR", "Armenian" ]
    ]
    ' as json_text
    )

    SELECT *
    FROM NATIONALITIES_JSON

    Here is how I would parse the JSON string in Oracle:


    I am on release 7.2.1.11 [Build 5] of Netezza.

    Thank you all.   

    ------------------------------
    David Briars
    ------------------------------
    #NetezzaPerformanceServer