Cloudera CDH/CDP 및 Hadoop EcoSystem, Semantic IoT등의 개발/운영 기술을 정리합니다. gooper@gooper.com로 문의 주세요.
*hue db에서 "test_user"가 가지고 있는 모든 workflow및 directory
select a.id, a.owner_id, b.username, a.name, a.uuid, a.type, a.is_hisotry from hue.desktop_document2 a, hue.auth_user b
where b.username='test_user' and a.owner_id=b.id and a.type in ('oozie-workflow2', 'directory') order by a.last_modified desc;
<쿼리 결과 예시>
id owner_id username name uuid type is_history
546371 1101125 test_user 5b8f6e0d-9da4-4e72-9dcb-21be68c22ad0 directory 0
546372 1101125 test_user .Trasht 3fdfsf6e0-dhda4-ef72-ssdb-43be68c32ad0 directory 0
546373 1101125 test_user wf_test 5b8f6e0d-9da4-1e72-9dcb-21be68c22ad0 oozie-workflow2 0
546374 1101125 test_user wf_test 7b8fdsff3f-35a4-2e72-9dcb-21be68c22ad0 oozie-workflow2 1
546375 1101125 test_user wf_test 8b8fsdfsdf-bghj-4e73-78cb-309beds822ff0 oozie-workflow2 1