Revision 47679
Added by Alessia Bardi almost 7 years ago
| queryClaimsUpdate.sql | ||
|---|---|---|
| 1 |
SELECT |
|
| 2 |
regexp_replace(xml, '<\?xml version="1\.0" encoding="UTF-8"\?>', '', 'i') AS xml, |
|
| 3 |
provenance |
|
| 4 |
FROM claims |
|
| 5 |
WHERE type = 'updates2actions' AND set = 'userclaim_dmf' |
|
| 1 |
-- SELECT
|
|
| 2 |
-- regexp_replace(xml, '<\?xml version="1\.0" encoding="UTF-8"\?>', '', 'i') AS xml,
|
|
| 3 |
-- provenance
|
|
| 4 |
-- FROM claims
|
|
| 5 |
-- WHERE type = 'updates2actions' AND set = 'userclaim_dmf'
|
|
| 6 | 6 |
|
| 7 |
SELECT source_type, source_id, target_type, target_id, semantics from claim where approved=true and source_type ='context'; |
|
| 7 | 8 |
|
| 9 |
|
|
Also available in: Unified diff
Classes and configuration for writing claimed relationships into HBASE