...
Code Block | ||||
---|---|---|---|---|
| ||||
select * from main_table |
Code Block | ||||
---|---|---|---|---|
| ||||
select mt.id as ID, mt.first_name, mt.last_name, mt.first_name + " " + mt.last_name AS full_name, , mt.col3, jt.col1, jt.col2, jt.col3 from main_table mt, joined_table jt where mt.id = jt.id |
Code Block | ||||
---|---|---|---|---|
| ||||
select * from main_table |
Code Block | ||||
---|---|---|---|---|
| ||||
select * from main_table where {slices} |
Code Block | ||||
---|---|---|---|---|
| ||||
select * from main_table where id mod 10 = 0 select * from main_table where id mod 10 = 1 select * from main_table where id mod 10 = 2 select * from main_table where id mod 10 = 3 select * from main_table where id mod 10 = 4 select * from main_table where id mod 10 = 5 select * from main_table where id mod 10 = 6 select * from main_table where id mod 10 = 7 select * from main_table where id mod 10 = 8 select * from main_table where id mod 10 = 9 |
...
...
Placeholder | Description |
---|---|
{documentId} | The document id from the column identified by the id column. |
{action} | The action from the column identified by the action column. |
{sequenceId} | The sequence from the column identified by the sequence column. |
{failed} | true if the submitted job failed, false otherwise. |
Code Block | ||||
---|---|---|---|---|
| ||||
UPDATE updates_table SET status='I' WHERE seq_id IN ( SELECT seq_id FROM updates_table WHERE status IS null OR ( status!='I' AND status != 'C' ) ORDER BY seq_id ASC FETCH FIRST 4 ROWS ONLY ) |
Code Block | ||||
---|---|---|---|---|
| ||||
SELECT updates_table.seq_id AS seq_id, updates_table.id AS doc_id, updates_table.action AS update_action, main_data.col1 AS cola, main_data.col2 AS colb, main_data.col3 AS coly, main_data.col4 AS colz FROM main_data RIGHT OUTER JOIN updates_table ON main_data.id = updates_table.id WHERE updates_table.status = 'I' ORDER BY updates_table.seq_id ASC |
Code Block | ||||
---|---|---|---|---|
| ||||
UPDATE updates_table SET status = 'C' WHERE seq_id = {sequenceId} |
...
...
Placeholder | Description |
---|---|
{lowerBound} | The lower bound for the crawl |
{upperBound} | The upper bound for the crawl |
Code Block | ||||
---|---|---|---|---|
| ||||
select * from main_table where modified_date > {lowerBound} and modified_date <= {upperBound} |
Code Block | ||||
---|---|---|---|---|
| ||||
select max(trans_id) from main_table |
Code Block | ||||
---|---|---|---|---|
| ||||
select * from main_table where trans_id > {lowerBound} and trans_id <= {upperBound} |