Example query and result

gistfile1.txt

** Postgres query
select * from properties join zips on properties.zip_code = zips.zip_code where property_id = 200000;
 property_id | zip_code | property_cost | home_insurance_rate | hoa_monthly_dues | construction_year | zip_code | property_tax_rate 
-------------+----------+---------------+---------------------+------------------+-------------------+----------+-------------------
      200000 |    11979 | $1,010,000.00 |               0.280 |          $850.00 |              1928 |    11979 |             0.914
(1 row)

** Cassandra query
select * from perch_dev.properties where property_id = 10000000;
 property_id                          | construction_year | hoa_monthly_dues | home_insurance_rate | property_cost | zip_code
--------------------------------------+-------------------+------------------+---------------------+---------------+----------
 10000000   |              1938 |              200 |                0.26 |        890000 |    39111

(1 rows)