sql - How to query logicblox -
i have entity predicate eg. "person" related functional predicates storing attributes entity.
eg.
person(x), person:id(x:s) -> string(s). person:dateofbirth[a] = b -> person(a), datetime(b). person:height[a] = b -> person(a), decimal(b). person:eyecolor[a] = b -> person(a), string(b). person:occupation[a] = b -> person(a), string(b).
what in terminal, equivalent of sql query:
select id, dateofbirth, eyecolor person
i aware of print command details of single functional predicate, combination of them.
lb print /workspace 'person:dateofbirth'
you can use "lb query" command execute arbitrary logiql queries against database. create temporary, anonymous, predicate results want see, , rule populating predicate using logiql language. in case like:
lb query <workspace> '_(id, dob, eye) <- person(p), person:id(p:id), person:dateofbirth[p] = dob, person:eyecolor[p] = eye.'
Comments
Post a Comment