Hello,
I am connecting Oracle Analytics to a Heatwave sql database. I can not create a dataset fetching any field that is of the type JSON. Also I can not insert any kinf of JSON function on the SQL command like :
select SUPI, JSON_EXTRACT (v,'$.user.userIds.DNN') as DNN from test.SmPolicyAssociation ;
I am trying to extract the DNN field of a JSON filed with this structure:
'{\"associationId\":\"87eed8f3-2784-401b-9960-7484844b0467\",\"createdTimestamp\":1551083246662,\"user\":{\"cid\":43,\"userIds\":{\"IPV6\":\"2001:0001:0022:3286:0000:0000:0000:0000\",\"DNN\":\"dnn1\",\"IPV4\":\"192.168.10.10\",\"SNSSAI\":\"11-abc123\",\"SUPI\":\"imsi-450081000008001\",\"GPSI\":\"9192503899\"}},\"smPolicyDecision\":{\"sessRules\":{\"0_1\":{\"authDefQos\":{\"5qi\":9,\"arp\":{\"priorityLevel\":1,\"preemptCap\":\"MAY_PREEMPT\",\"preemptVuln\":\"NOT_PREEMPTABLE\"}},\"sessRuleId\":\"0_1\"}},\"pccRules\":{\"0_0\":{\"flowInfos\":[{\"flowDescription\":\"permit in ip from any to any\",\"flowDirection\":\"UPLINK\"},{\"flowDescription\":\"permit out ip from any to any\",\"flowDirection\":\"DOWNLINK\"}],\"pccRuleId\":\"0_0\",\"precedence\":3000,\"refQosData\":[\"qosdata_0\"],\"refChgData\":[\"chgdata_0\"]}},\"qosDecs\":{\"qosdata_0\":{\"5qi\":9,\"qosId\":\"qosdata_0\",\"arp\":{\"priorityLevel\":1,\"preemptCap\":\"MAY_PREEMPT\",\"preemptVuln\":\"NOT_PREEMPTABLE\"}}},\"chgDecs\":{\"chgdata_0\":{\"chgId\":\"chgdata_0\"}},\"policyCtrlReqTriggers\":[\"PLMN_CH\",\"UE_IP_CH\",\"DEF_QOS_CH\",\"AC_TY_CH\"]},\"smPolicyContextData\":{\"3gppPsDataOffStatus\":true,\"accNetChId\":{\"accNetChaIdValue\":\"01020304\",\"sessionChScope\":true},\"gpsi\":\"9192503899\",\"supi\":\"imsi-450081000008001\",\"pduSessionId\":1,\"pduSessionType\":\"IPV4\",\"dnn\":\"dnn1\",\"notificationUri\":\http://smf-simulator:8080/smf/notify\,\"accessType\":\"3GPP_ACCESS\",\"ratType\":\"EUTRA\",\"servingNetwork\":{\"mnc\":\"08\",\"mcc\":\"450\"},\"ueTimeZone\":\"+08:00\",\"pei\":\"990000862471854\",\"ipv4Address\":\"192.168.10.10\",\"ipv6AddressPrefix\":\"2001:1:22:3286::/64\",\"online\":false,\"offline\":true,\"sliceInfo\":{\"sst\":11,\"sd\":\"abc123\"},\"userLocationInformation\":{\"nrLocation\":{\"ncgi\":{\"nrCellId\":\"512\",\"plmnId\":{\"mcc\":\"450\",\"mnc\":\"08\"}},\"tai\":{\"plmnId\":{\"mcc\":\"450\",\"mnc\":\"08\"},\"tac\":\"1801\"}}},\"supportedFeatures\":\"\",\"smPoliciesUpdateNotificationUrl\":\"npcf-smpolicycontrol/v1/sm-policies/{ueId}/notify\",\"subSessAmbr\":{\"downlink\":\"1000000 Kbps\",\"uplink\":\"10000 Kbps\"},\"subscribedDefaultQosInformation\":\"FFS\"},\"defaultPccRuleId\":\"0_0\",\"ruleIdCounter\":2,\"qosDataIdCounter\":1,\"chgDataIdCounter\":1,\"precedenceValue\":0,\"modelObjectId\":\"87eed8f3-2784-401b-9960-7484844b0467\"}'
Any idea about why I can not use any JSON QSL command?