Advertisement
thisisvld

Untitled

Nov 20th, 2018
341
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 1.15 KB | None | 0 0
  1. dbadmin=> SELECT projection_name,projection_schema,anchor_table_name,segment_range,is_up_to_date FROM projections WHERE anchor_table_name='admin' AND projection_schema='beta';
  2.   projection_name   | projection_schema | anchor_table_name |                                         segment_range                                         | is_up_to_date
  3. --------------------+-------------------+-------------------+-----------------------------------------------------------------------------------------------+---------------
  4.  admin_super_k1_b0  | beta              | admin             | implicit range: v_diavita_node0003[33.3%] v_diavita_node0001[33.3%] v_diavita_node0002[33.3%] | t
  5.  admin_super_k1_b1  | beta              | admin             | implicit range: v_diavita_node0001[33.3%] v_diavita_node0002[33.3%] v_diavita_node0003[33.3%] | t
  6.  admin_ukcol2_k1_b0 | beta              | admin             | implicit range: v_diavita_node0003[33.3%] v_diavita_node0001[33.3%] v_diavita_node0002[33.3%] | t
  7.  admin_ukcol2_k1_b1 | beta              | admin             | implicit range: v_diavita_node0001[33.3%] v_diavita_node0002[33.3%] v_diavita_node0003[33.3%] | t
  8. (4 ROWS)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement