Skip to content

Instantly share code, notes, and snippets.

@dyangrev

dyangrev/c*

Created September 15, 2017 19:17
Show Gist options
  • Save dyangrev/1e7323a49e7cc10b1ae5d32bc39b6ab6 to your computer and use it in GitHub Desktop.
Save dyangrev/1e7323a49e7cc10b1ae5d32bc39b6ab6 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
c*
```
cqlsh:dossier_test_1> select * from merged_prop_profiles where profile_ids_for_search like '%FILE<->piper<->thedurhamhotel<->DC7624653B3CEAA46661FD6227572758383D522A%' ;
id | badges | company_info | contact_list_ids | created_at | credit_cards | date_of_birth | day_of_birth | email_addresses | first_name | gender | guest_notes | last_name | mail_opt_out | memberships | middle_name | month_of_birth | name_type | phone_numbers | photo_url | postal_addresses | primary_company | primary_credit_card | primary_email_address | primary_language | primary_phone_number | primary_postal_address | profile_ids | profile_ids_for_search | profile_type | property_id | reservation_ids | subscription_status | survey_nps | title | total_number_of_canceled_stays | total_number_of_stays | total_number_of_valid_nights | total_number_of_valid_stays | total_room_revenue | updated_at | vip_status | year_of_birth
--------------------------------------+---------------+---------------+------------------+---------------------------------+---------------+---------------+--------------+-----------------+--------------+---------+---------------+-----------+--------------+---------------+-------------+----------------+---------------+--------------------------------------------------------------------------------------------------------------------------+-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------+---------------------+-----------------------+------------------+-------------------------------------------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+--------------+-------------+-----------------+---------------------+--------------------------------------------------------------+-------+--------------------------------+-----------------------+------------------------------+-----------------------------+--------------------+---------------------------------+------------+---------------
860adac0-98cf-11e7-8313-414ff1b6f378 | SortedSet([]) | SortedSet([]) | SortedSet([]) | 2017-09-13 22:04:42.040000+0000 | SortedSet([]) | null | null | SortedSet([]) | Allison Pell | unknown | SortedSet([]) | Tanner | null | SortedSet([]) | null | null | SortedSet([]) | SortedSet([phone_number(phone_number=u'+18284297755', phone_number_type=u'OTHER', is_primary=True, inactive_date=None)]) | null | SortedSet([geocoded_address(address1=None, address2=None, city=None, state=None, country=None, zip_code=None, address_type=u'OTHER', is_primary=False, inactive_date=None, g_locality=None, g_locality_short=None, g_administrative_area_level_1=None, g_administrative_area_level_1_short=None, g_administrative_area_level_2=None, g_administrative_area_level_2_short=None, g_administrative_area_level_3=None, g_administrative_area_level_3_short=None, g_administrative_area_level_4=None, g_administrative_area_level_4_short=None, g_administrative_area_level_5=None, g_administrative_area_level_5_short=None, g_country=None, g_country_short=None, g_latitude=None, g_longitude=None), geocoded_address(address1=None, address2=None, city=None, state=None, country=u'US', zip_code=None, address_type=u'OTHER', is_primary=True, inactive_date=None, g_locality=None, g_locality_short=None, g_administrative_area_level_1=None, g_administrative_area_level_1_short=None, g_administrative_area_level_2=None, g_administrative_area_level_2_short=None, g_administrative_area_level_3=None, g_administrative_area_level_3_short=None, g_administrative_area_level_4=None, g_administrative_area_level_4_short=None, g_administrative_area_level_5=None, g_administrative_area_level_5_short=None, g_country=u'United States', g_country_short=u'US', g_latitude=Decimal('43.2994285'), g_longitude=Decimal('-74.21793260000001'))]) | null | null | null | eng | phone_number(phone_number=u'+18284297755', phone_number_type=u'OTHER', is_primary=True, inactive_date=None) | geocoded_address(address1=None, address2=None, city=None, state=None, country=u'US', zip_code=None, address_type=u'OTHER', is_primary=True, inactive_date=None, g_locality=None, g_locality_short=None, g_administrative_area_level_1=None, g_administrative_area_level_1_short=None, g_administrative_area_level_2=None, g_administrative_area_level_2_short=None, g_administrative_area_level_3=None, g_administrative_area_level_3_short=None, g_administrative_area_level_4=None, g_administrative_area_level_4_short=None, g_administrative_area_level_5=None, g_administrative_area_level_5_short=None, g_country=u'United States', g_country_short=u'US', g_latitude=Decimal('43.2994285'), g_longitude=Decimal('-74.21793260000001')) | SortedSet([u'FILE<->piper<->thedurhamhotel<->DC7624653B3CEAA46661FD6227572758383D522A', u'FILE<->piper<->thedurhamhotel<->FB3E718ACBD31CE38DFBC8F99BE384EA7BE2CD9C']) | FILE<->piper<->thedurhamhotel<->FB3E718ACBD31CE38DFBC8F99BE384EA7BE2CD9C FILE<->piper<->thedurhamhotel<->DC7624653B3CEAA46661FD6227572758383D522A | GUEST | 1001134 | SortedSet([]) | {} | survey_nps(current=None, detractor=0, passive=0, promoter=0) | null | 0 | 0 | 0 | 0 | 0 | 2017-09-15 19:08:19.290000+0000 | null | null
(1 rows)
Failed to format value SortedSet([]) : 'NoneType' object has no attribute 'get_n_sub_types'
Failed to format value SortedSet([]) : 'NoneType' object has no attribute 'get_n_sub_types'
10 more decoding errors suppressed.
```
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment