I'm trying to access data in both the auth and radius_acct tables in the InsightDB however I am having an issue with the join. In the auth table, the session_id is stored as a varchar however in the radius_acct the session is stored in a json array.
Does anyone know how to create a join between these two tables with these columns?
select session_id from auth limit 1
select session_id from radius_acct limit 1
The radius_acct.session_id is a text array. To reference the first element you can user radius_acct.session. And the second using radius_acct.session, etc
I'm not great at SQL but this seems to work:
SELECT * FROM authJOIN radius_acct ON auth.session_id = ANY (radius_acct.session_id)
Thanks that did it, so easy
If the file is password protected, enter the password in the Enter secret for the file field TellPopeyes.
At Aruba, we believe that the most dynamic customer experiences happen at the Edge. Our mission is to deliver innovative solutions that harness data at the Edge to drive powerful business outcomes.
© Copyright 2021 Hewlett Packard Enterprise Development LPAll Rights Reserved.