tgrall/mapr-beta-labs.md

## mapr-beta-labs.md

      
    Raw
  

              mapr-beta-labs.md
            
          
    Lab 1


select customer_id from dfs.root.`/user/mapr/product_sales` where customer_id=1288034;


Open another terminal and create the following indices


maprcli table index add -path /user/mapr/product_sales -index index_customer_id -indexedfields '"customer_id"'

maprcli table index list -path /user/mapr/product_sales -json


select customer_id from dfs.root.`/user/mapr/product_sales` where customer_id > 1288034 and customer_id<=1288037 order by customer_id;


select customer_id from dfs.root.`/user/mapr/product_sales` where customer_id > 1288034 and customer_id<=1288037 order by customer_id desc;


select customer_id from dfs.root.`/user/mapr/product_sales` where customer_id between 1288036 and 1288039;