You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@zeppelin.apache.org by fe...@apache.org on 2016/01/24 19:04:58 UTC
[4/6] incubator-zeppelin git commit: [ZEPPELIN-559] Cassandra
interpreter v2
http://git-wip-us.apache.org/repos/asf/incubator-zeppelin/blob/11a45e2e/cassandra/src/test/resources/scalate/DescribeKeyspace_live_data.html
----------------------------------------------------------------------
diff --git a/cassandra/src/test/resources/scalate/DescribeKeyspace_live_data.html b/cassandra/src/test/resources/scalate/DescribeKeyspace_live_data.html
index 09e7342..344780a 100644
--- a/cassandra/src/test/resources/scalate/DescribeKeyspace_live_data.html
+++ b/cassandra/src/test/resources/scalate/DescribeKeyspace_live_data.html
@@ -1,819 +1 @@
-<br/>
-<br/>
-<nav class="navbar navbar-default">
- <ul class="nav navbar-nav">
-
- <li role="presentation" class="dropdown">
- <a class="dropdown-toggle" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false">
- <span class="text-danger"><i class="glyphicon glyphicon-folder-open"/> <strong>live_data</strong></span>
- <span class="text-danger caret"></span>
- <ul class="dropdown-menu">
-
-
- <li class="dropdown-header"><span class="text-primary">Tables</span></li>
- <li>
- <a role="button" data-toggle="collapse" data-target="#91e7ac20-3516-11e5-9d5f-8f0ea8ae1a37">
- <span class="text-primary"><i class="glyphicon glyphicon-th-list"/> complex_table</span>
- </a>
- </li>
- <li>
- <a role="button" data-toggle="collapse" data-target="#93e1a760-3516-11e5-9d5f-8f0ea8ae1a37">
- <span class="text-primary"><i class="glyphicon glyphicon-th-list"/> sensor_data</span>
- </a>
- </li>
- <li>
- <a role="button" data-toggle="collapse" data-target="#93e306f0-3516-11e5-9d5f-8f0ea8ae1a37">
- <span class="text-primary"><i class="glyphicon glyphicon-th-list"/> stations</span>
- </a>
- </li>
-
-
-
- <li role="separator" class="divider text-muted"></li>
- <li class="dropdown-header"><span class="text-warning">User Defined Types</span></li>
- <li>
- <a role="button" data-toggle="collapse" data-target="#93e48d90-3516-11e5-9d5f-8f0ea8ae1a37">
- <span class="text-warning"><i class="glyphicon glyphicon-copyright-mark"/> address</span>
- </a>
- </li>
- <li>
- <a role="button" data-toggle="collapse" data-target="#942c9310-3516-11e5-9d5f-8f0ea8ae1a37">
- <span class="text-warning"><i class="glyphicon glyphicon-copyright-mark"/> geolocation</span>
- </a>
- </li>
- </ul>
- </a>
- </li>
- <li>
- <a><strong>DESCRIBE KEYSPACE live_data;</strong></a>
- </li>
- </ul>
- <ul class="nav navbar-nav navbar-right">
- <li class="dropdown">
- <a class="dropdown-toggle" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false">
- <strong>Legend</strong>
- <span class="caret"></span>
- </a>
- <ul class="dropdown-menu">
- <li>
- <a role="button">
- <i class="glyphicon glyphicon-dashboard text-muted" /> Cluster
- </a>
- </li>
- <li>
- <a role="button">
- <i class="glyphicon glyphicon-folder-open text-danger" /> Keyspace
- </a>
- </li>
- <li>
- <a role="button">
- <i class="glyphicon glyphicon-copyright-mark text-warning" /> UDT
- </a>
- </li>
- <li>
- <a role="button">
- <i class="glyphicon glyphicon-th-list text-primary" /> Table
- </a>
- </li>
- <li class="bg-info">
- <a role="button">
- <i class="glyphicon glyphicon-fullscreen" /> Partition Key
- </a>
- </li>
- <li class="bg-warning">
- <a role="button">
- <i class="glyphicon glyphicon-pushpin" /> Static Column
- </a>
- </li>
- <li class="bg-success">
- <a role="button">
- <i class="glyphicon glyphicon-sort" /> Clustering Column
- </a>
- </li>
- <li class="bg-success">
- <a role="button">
- <i class="glyphicon glyphicon-sort-by-attributes" /> Clustering Order ASC
- </a>
- </li>
- <li class="bg-success">
- <a role="button">
- <i class="glyphicon glyphicon-sort-by-attributes-alt" /> Clustering Order DESC
- </a>
- </li>
- <li>
- <a role="button">
- <i class="glyphicon glyphicon-info-sign" /> Indexed Column
- </a>
- </li>
- </ul>
- </li>
- <li>
- <a href="#"></a>
- </li>
- </ul>
-</nav>
-<hr/>
-<div class="container">
- <!-- Keyspace -->
-
-
- <div class="row">
- <div class="col-md-2"></div>
- <div class="col-md-8 col-offset-md-2">
- <div class="panel panel-default table-responsive table-bordered">
- <table class="table">
- <thead>
- <tr>
- <th class="col-md-10">Replication</th>
- <th class="col-md-2">Durable Writes</th>
- </tr>
- </thead>
- <tbody>
- <tr>
- <td class="col-md-10">{'replication_factor' : '1', 'class' : 'org.apache.cassandra.locator.SimpleStrategy'}</td>
- <td class="col-md-2">false</td>
- </tr>
- <tbody>
- </table>
- <div class="panel-footer">
- <a data-toggle="collapse" data-target="#8db09220-3516-11e5-9d5f-8f0ea8ae1a37_asCQL">
- <strong>As CQL statement</strong>
- <span class="caret"></span>
- </a>
- <br/><br/>
- <div class="collapse" id="8db09220-3516-11e5-9d5f-8f0ea8ae1a37_asCQL">
- <pre class="well">CREATE KEYSPACE live_data WITH REPLICATION = {
- 'class' : 'org.apache.cassandra.locator.SimpleStrategy',
- 'replication_factor': '1' }
-AND DURABLE_WRITES = false;</pre>
- </div>
- </div>
- </div>
- </div>
- <div class="col-md-2"></div>
- </div>
-
- <!-- Tables -->
- <div class="row"></div>
-
-
- <table width="100%">
- <td><hr /></td>
- <td style="width:1px; padding: 0 10px; white-space: nowrap;"><strong class="text-primary">Tables</strong></td>
- <td><hr /></td>
- </table>
- <div class="row">
- <div class="panel-group" role="tablist" aria-multiselectable="true">
-
- <div class="panel panel-default">
- <div class="panel-heading" role="tab">
- <h4 class="panel-title">
- <a role="button" data-toggle="collapse" data-target="#91e7ac20-3516-11e5-9d5f-8f0ea8ae1a37" aria-expanded="false">
- <span class="text-primary">
- <i class="glyphicon glyphicon-th-list"/> complex_table
- </span>
- </a>
- </h4>
- </div>
- <div id="91e7ac20-3516-11e5-9d5f-8f0ea8ae1a37" class="panel-collapse collapse" role="tabpanel">
- <div class="panel-body">
-
- <div class="row">
- <div class="col-md-2"/>
- <div class="col-md-8 col-offset-md-2">
- <div class="panel panel-default table-responsive table-bordered">
- <table class="table">
- <thead>
- <tr>
- <th class="col-md-4">Column Type</th>
- <th class="col-md-4">Column Name</th>
- <th class="col-md-4">Data Type</th>
- </tr>
- </thead>
- <tbody>
-
-
- <tr class="info">
- <td class="col-md-4">
- <i class="glyphicon glyphicon-fullscreen" title="Partition Key"/>
-
- <span></span>
-
- </td>
- <td class="col-md-4">pk1</td>
- <td class="col-md-4">uuid</td>
- </tr>
-
-
- <tr class="info">
- <td class="col-md-4">
- <i class="glyphicon glyphicon-fullscreen" title="Partition Key"/>
-
-
- <i class="glyphicon glyphicon-info-sign" title="Indexed Column"/>
- <em>pk2idx</em> <strong></strong>
-
- </td>
- <td class="col-md-4">pk2</td>
- <td class="col-md-4">int</td>
- </tr>
-
- <tr class="warning">
- <td class="col-md-4">
- <i class="glyphicon glyphicon-pushpin" title="Static Column"/>
-
- <span></span>
-
- </td>
- <td class="col-md-4">my_static1</td>
- <td class="col-md-4">text</td>
- </tr>
-
- <tr class="warning">
- <td class="col-md-4">
- <i class="glyphicon glyphicon-pushpin" title="Static Column"/>
-
- <span></span>
-
- </td>
- <td class="col-md-4">my_static2</td>
- <td class="col-md-4">text</td>
- </tr>
-
- <tr class="success">
- <td class="col-md-4">
- <i class="glyphicon glyphicon-sort" title="Clustering Column"/>
-
- <i class="glyphicon glyphicon-sort-by-attributes-alt" title="Sort DESC"/>
-
- <span></span>
-
- </td>
- <td class="col-md-4">clustering1</td>
- <td class="col-md-4">timestamp</td>
- </tr>
-
- <tr class="success">
- <td class="col-md-4">
- <i class="glyphicon glyphicon-sort" title="Clustering Column"/>
-
- <i class="glyphicon glyphicon-sort-by-attributes" title="Sort ASC"/>
-
-
- <i class="glyphicon glyphicon-info-sign" title="Indexed Column"/>
- <em>clustering2idx</em> <strong></strong>
-
- </td>
- <td class="col-md-4">clustering2</td>
- <td class="col-md-4">int</td>
- </tr>
-
- <tr class="success">
- <td class="col-md-4">
- <i class="glyphicon glyphicon-sort" title="Clustering Column"/>
-
- <i class="glyphicon glyphicon-sort-by-attributes-alt" title="Sort DESC"/>
-
- <span></span>
-
- </td>
- <td class="col-md-4">clustering3</td>
- <td class="col-md-4">text</td>
- </tr>
-
- <tr>
- <td class="col-md-4">
-
- <span></span>
-
- </td>
- <td class="col-md-4">entries_indexed_map</td>
- <td class="col-md-4">map<int, text></td>
- </tr>
-
- <tr>
- <td class="col-md-4">
-
-
- <i class="glyphicon glyphicon-info-sign" title="Indexed Column"/>
- <em>idx1</em> <strong></strong>
-
- </td>
- <td class="col-md-4">indexed1</td>
- <td class="col-md-4">text</td>
- </tr>
-
- <tr>
- <td class="col-md-4">
-
-
- <i class="glyphicon glyphicon-info-sign" title="Indexed Column"/>
- <em>idx2</em> <strong></strong>
-
- </td>
- <td class="col-md-4">indexed2</td>
- <td class="col-md-4">int</td>
- </tr>
-
- <tr>
- <td class="col-md-4">
-
-
- <i class="glyphicon glyphicon-info-sign" title="Indexed Column"/>
- <em>keys_map_idx</em> <strong></strong>
-
- </td>
- <td class="col-md-4">key_indexed_map</td>
- <td class="col-md-4">map<int, text></td>
- </tr>
-
- <tr>
- <td class="col-md-4">
-
- <span></span>
-
- </td>
- <td class="col-md-4">my_list</td>
- <td class="col-md-4">list<text></td>
- </tr>
-
- <tr>
- <td class="col-md-4">
-
- <span></span>
-
- </td>
- <td class="col-md-4">my_map</td>
- <td class="col-md-4">map<int, text></td>
- </tr>
-
- <tr>
- <td class="col-md-4">
-
- <span></span>
-
- </td>
- <td class="col-md-4">my_udt</td>
- <td class="col-md-4">frozen<live_data.address></td>
- </tr>
-
- <tr>
- <td class="col-md-4">
-
- <span></span>
-
- </td>
- <td class="col-md-4">my_udt_list</td>
- <td class="col-md-4">frozen<list<frozen<live_data.address>>></td>
- </tr>
-
- <tr>
- <td class="col-md-4">
-
- <span></span>
-
- </td>
- <td class="col-md-4">simple</td>
- <td class="col-md-4">double</td>
- </tr>
-
- </tbody>
- </table>
- <div class="panel-footer">
- <a data-toggle="collapse" data-target="#91eb0780-3516-11e5-9d5f-8f0ea8ae1a37_asCQL">
- <strong>As CQL statement</strong>
- <span class="caret"></span>
- </a>
- <br/><br/>
- <div class="collapse" id="91eb0780-3516-11e5-9d5f-8f0ea8ae1a37_asCQL">
- <pre class="well">CREATE TABLE live_data.complex_table (
- pk1 uuid,
- pk2 int,
- clustering1 timestamp,
- clustering2 int,
- clustering3 text,
- entries_indexed_map map<int, text>,
- indexed1 text,
- indexed2 int,
- key_indexed_map map<int, text>,
- my_list list<text>,
- my_map map<int, text>,
- my_static1 text static,
- my_static2 text static,
- my_udt frozen<live_data.address>,
- my_udt_list frozen<list<frozen<live_data.address>>>,
- simple double,
- PRIMARY KEY ((pk1, pk2), clustering1, clustering2, clustering3)
-) WITH CLUSTERING ORDER BY (clustering1 DESC, clustering2 ASC, clustering3 DESC)
- AND read_repair_chance = 0.0
- AND dclocal_read_repair_chance = 0.1
- AND gc_grace_seconds = 864000
- AND bloom_filter_fp_chance = 0.01
- AND caching = { 'keys' : 'ALL', 'rows_per_partition' : 'NONE' }
- AND comment = ''
- AND compaction = { 'class' : 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy' }
- AND compression = { 'sstable_compression' : 'org.apache.cassandra.io.compress.LZ4Compressor' }
- AND default_time_to_live = 0
- AND speculative_retry = '99.0PERCENTILE'
- AND min_index_interval = 128
- AND max_index_interval = 2048;
-CREATE INDEX pk2idx ON live_data.complex_table (pk2);
-CREATE INDEX clustering2idx ON live_data.complex_table (clustering2);
-CREATE INDEX idx1 ON live_data.complex_table (indexed1);
-CREATE INDEX idx2 ON live_data.complex_table (indexed2);
-CREATE INDEX keys_map_idx ON live_data.complex_table (KEYS(key_indexed_map));</pre>
- </div>
- </div>
- </div>
- </div>
- <div class="col-md-2"></div>
- </div>
- </div>
- </div>
- </div>
-
- <div class="panel panel-default">
- <div class="panel-heading" role="tab">
- <h4 class="panel-title">
- <a role="button" data-toggle="collapse" data-target="#93e1a760-3516-11e5-9d5f-8f0ea8ae1a37" aria-expanded="false">
- <span class="text-primary">
- <i class="glyphicon glyphicon-th-list"/> sensor_data
- </span>
- </a>
- </h4>
- </div>
- <div id="93e1a760-3516-11e5-9d5f-8f0ea8ae1a37" class="panel-collapse collapse" role="tabpanel">
- <div class="panel-body">
-
- <div class="row">
- <div class="col-md-2"/>
- <div class="col-md-8 col-offset-md-2">
- <div class="panel panel-default table-responsive table-bordered">
- <table class="table">
- <thead>
- <tr>
- <th class="col-md-4">Column Type</th>
- <th class="col-md-4">Column Name</th>
- <th class="col-md-4">Data Type</th>
- </tr>
- </thead>
- <tbody>
-
-
- <tr class="info">
- <td class="col-md-4">
- <i class="glyphicon glyphicon-fullscreen" title="Partition Key"/>
-
- <span></span>
-
- </td>
- <td class="col-md-4">sensor_id</td>
- <td class="col-md-4">uuid</td>
- </tr>
-
-
- <tr class="info">
- <td class="col-md-4">
- <i class="glyphicon glyphicon-fullscreen" title="Partition Key"/>
-
- <span></span>
-
- </td>
- <td class="col-md-4">month</td>
- <td class="col-md-4">int</td>
- </tr>
-
- <tr class="warning">
- <td class="col-md-4">
- <i class="glyphicon glyphicon-pushpin" title="Static Column"/>
-
- <span></span>
-
- </td>
- <td class="col-md-4">characteristics</td>
- <td class="col-md-4">map<text, text></td>
- </tr>
-
- <tr class="warning">
- <td class="col-md-4">
- <i class="glyphicon glyphicon-pushpin" title="Static Column"/>
-
- <span></span>
-
- </td>
- <td class="col-md-4">model_number</td>
- <td class="col-md-4">text</td>
- </tr>
-
- <tr class="warning">
- <td class="col-md-4">
- <i class="glyphicon glyphicon-pushpin" title="Static Column"/>
-
- <span></span>
-
- </td>
- <td class="col-md-4">provider</td>
- <td class="col-md-4">text</td>
- </tr>
-
- <tr class="success">
- <td class="col-md-4">
- <i class="glyphicon glyphicon-sort" title="Clustering Column"/>
-
- <i class="glyphicon glyphicon-sort-by-attributes-alt" title="Sort DESC"/>
-
- <span></span>
-
- </td>
- <td class="col-md-4">date</td>
- <td class="col-md-4">timestamp</td>
- </tr>
-
- <tr>
- <td class="col-md-4">
-
- <span></span>
-
- </td>
- <td class="col-md-4">value</td>
- <td class="col-md-4">double</td>
- </tr>
-
- </tbody>
- </table>
- <div class="panel-footer">
- <a data-toggle="collapse" data-target="#93e1a761-3516-11e5-9d5f-8f0ea8ae1a37_asCQL">
- <strong>As CQL statement</strong>
- <span class="caret"></span>
- </a>
- <br/><br/>
- <div class="collapse" id="93e1a761-3516-11e5-9d5f-8f0ea8ae1a37_asCQL">
- <pre class="well">CREATE TABLE live_data.sensor_data (
- sensor_id uuid,
- month int,
- date timestamp,
- characteristics map<text, text> static,
- model_number text static,
- provider text static,
- value double,
- PRIMARY KEY ((sensor_id, month), date)
-) WITH CLUSTERING ORDER BY (date DESC)
- AND read_repair_chance = 0.0
- AND dclocal_read_repair_chance = 0.1
- AND gc_grace_seconds = 864000
- AND bloom_filter_fp_chance = 0.01
- AND caching = { 'keys' : 'ALL', 'rows_per_partition' : 'NONE' }
- AND comment = ''
- AND compaction = { 'class' : 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy' }
- AND compression = { 'sstable_compression' : 'org.apache.cassandra.io.compress.LZ4Compressor' }
- AND default_time_to_live = 0
- AND speculative_retry = '99.0PERCENTILE'
- AND min_index_interval = 128
- AND max_index_interval = 2048;</pre>
- </div>
- </div>
- </div>
- </div>
- <div class="col-md-2"></div>
- </div>
- </div>
- </div>
- </div>
-
- <div class="panel panel-default">
- <div class="panel-heading" role="tab">
- <h4 class="panel-title">
- <a role="button" data-toggle="collapse" data-target="#93e306f0-3516-11e5-9d5f-8f0ea8ae1a37" aria-expanded="false">
- <span class="text-primary">
- <i class="glyphicon glyphicon-th-list"/> stations
- </span>
- </a>
- </h4>
- </div>
- <div id="93e306f0-3516-11e5-9d5f-8f0ea8ae1a37" class="panel-collapse collapse" role="tabpanel">
- <div class="panel-body">
-
- <div class="row">
- <div class="col-md-2"/>
- <div class="col-md-8 col-offset-md-2">
- <div class="panel panel-default table-responsive table-bordered">
- <table class="table">
- <thead>
- <tr>
- <th class="col-md-4">Column Type</th>
- <th class="col-md-4">Column Name</th>
- <th class="col-md-4">Data Type</th>
- </tr>
- </thead>
- <tbody>
-
-
- <tr class="info">
- <td class="col-md-4">
- <i class="glyphicon glyphicon-fullscreen" title="Partition Key"/>
-
- <span></span>
-
- </td>
- <td class="col-md-4">station_id</td>
- <td class="col-md-4">uuid</td>
- </tr>
-
- <tr>
- <td class="col-md-4">
-
- <span></span>
-
- </td>
- <td class="col-md-4">sensors</td>
- <td class="col-md-4">frozen<map<uuid, frozen<live_data.geolocation>>></td>
- </tr>
-
- </tbody>
- </table>
- <div class="panel-footer">
- <a data-toggle="collapse" data-target="#93e306f1-3516-11e5-9d5f-8f0ea8ae1a37_asCQL">
- <strong>As CQL statement</strong>
- <span class="caret"></span>
- </a>
- <br/><br/>
- <div class="collapse" id="93e306f1-3516-11e5-9d5f-8f0ea8ae1a37_asCQL">
- <pre class="well">CREATE TABLE live_data.stations (
- station_id uuid,
- sensors frozen<map<uuid, frozen<live_data.geolocation>>>,
- PRIMARY KEY (station_id)
-) WITH read_repair_chance = 0.0
- AND dclocal_read_repair_chance = 0.1
- AND gc_grace_seconds = 864000
- AND bloom_filter_fp_chance = 0.01
- AND caching = { 'keys' : 'ALL', 'rows_per_partition' : 'NONE' }
- AND comment = ''
- AND compaction = { 'class' : 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy' }
- AND compression = { 'sstable_compression' : 'org.apache.cassandra.io.compress.LZ4Compressor' }
- AND default_time_to_live = 0
- AND speculative_retry = '99.0PERCENTILE'
- AND min_index_interval = 128
- AND max_index_interval = 2048;</pre>
- </div>
- </div>
- </div>
- </div>
- <div class="col-md-2"></div>
- </div>
- </div>
- </div>
- </div>
-
- </div>
- </div>
-
-
- <!-- UDTs -->
- <table width="100%">
- <td><hr /></td>
- <td style="width:1px; padding: 0 10px; white-space: nowrap;"><strong class="text-warning">User Defined Types</strong></td>
- <td><hr /></td>
- </table>
- <div class="row">
- <div class="panel-group" role="tablist" aria-multiselectable="true">
-
- <div class="panel panel-default">
- <div class="panel-heading" role="tab">
- <h4 class="panel-title">
- <a role="button" data-toggle="collapse" data-target="#93e48d90-3516-11e5-9d5f-8f0ea8ae1a37" aria-expanded="false">
- <span class="text-warning"><i class="glyphicon glyphicon-copyright-mark"/> address</span>
- </a>
- </h4>
- </div>
- <div id="93e48d90-3516-11e5-9d5f-8f0ea8ae1a37" class="panel-collapse collapse" role="tabpanel">
- <div class="panel-body">
-
- <div class="row">
- <div class="col-md-3"></div>
- <div class="col-md-6 col-offset-md-3">
- <div class="panel panel-default table-responsive table-bordered">
- <table class="table">
-
- <thead>
- <tr>
- <th class="col-md-6">Column Name</th>
- <th class="col-md-6">Data Type</th>
- </tr>
- </thead>
- <tbody>
-
- <tr>
- <td class="col-md-6">number</td>
- <td class="col-md-6">int</td>
- </tr>
-
- <tr>
- <td class="col-md-6">street</td>
- <td class="col-md-6">text</td>
- </tr>
-
- <tr>
- <td class="col-md-6">zip</td>
- <td class="col-md-6">int</td>
- </tr>
-
- <tr>
- <td class="col-md-6">city</td>
- <td class="col-md-6">text</td>
- </tr>
-
- <tr>
- <td class="col-md-6">country</td>
- <td class="col-md-6">text</td>
- </tr>
-
- <tbody>
- </table>
- <div class="panel-footer">
- <a data-toggle="collapse" data-target="#93e529d0-3516-11e5-9d5f-8f0ea8ae1a37_asCQL">
- <strong>As CQL statement</strong>
- <span class="caret"></span>
- </a>
- <br/><br/>
- <div class="collapse" id="93e529d0-3516-11e5-9d5f-8f0ea8ae1a37_asCQL">
- <pre class="well">CREATE TYPE live_data.address (
- number int,
- street text,
- zip int,
- city text,
- country text
-);</pre>
- </div>
- </div>
- </div>
- </div>
- <div class="col-md-3"></div>
- </div>
-
- </div>
- </div>
- </div>
-
- <div class="panel panel-default">
- <div class="panel-heading" role="tab">
- <h4 class="panel-title">
- <a role="button" data-toggle="collapse" data-target="#942c9310-3516-11e5-9d5f-8f0ea8ae1a37" aria-expanded="false">
- <span class="text-warning"><i class="glyphicon glyphicon-copyright-mark"/> geolocation</span>
- </a>
- </h4>
- </div>
- <div id="942c9310-3516-11e5-9d5f-8f0ea8ae1a37" class="panel-collapse collapse" role="tabpanel">
- <div class="panel-body">
-
- <div class="row">
- <div class="col-md-3"></div>
- <div class="col-md-6 col-offset-md-3">
- <div class="panel panel-default table-responsive table-bordered">
- <table class="table">
-
- <thead>
- <tr>
- <th class="col-md-6">Column Name</th>
- <th class="col-md-6">Data Type</th>
- </tr>
- </thead>
- <tbody>
-
- <tr>
- <td class="col-md-6">latitude</td>
- <td class="col-md-6">double</td>
- </tr>
-
- <tr>
- <td class="col-md-6">longitude</td>
- <td class="col-md-6">double</td>
- </tr>
-
- <tbody>
- </table>
- <div class="panel-footer">
- <a data-toggle="collapse" data-target="#942c9311-3516-11e5-9d5f-8f0ea8ae1a37_asCQL">
- <strong>As CQL statement</strong>
- <span class="caret"></span>
- </a>
- <br/><br/>
- <div class="collapse" id="942c9311-3516-11e5-9d5f-8f0ea8ae1a37_asCQL">
- <pre class="well">CREATE TYPE live_data.geolocation (
- latitude double,
- longitude double
-);</pre>
- </div>
- </div>
- </div>
- </div>
- <div class="col-md-3"></div>
- </div>
-
- </div>
- </div>
- </div>
-
- </div>
- </div>
-
-</div>
\ No newline at end of file
+<br/><br/><nav class="navbar navbar-default"><ul class="nav navbar-nav"><li role="presentation" class="dropdown"><a class="dropdown-toggle" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false"><span class="text-danger"><i class="glyphicon glyphicon-folder-open"/> <strong>live_data</strong></span><span class="text-danger caret"></span><ul class="dropdown-menu"><li class="dropdown-header"><span class="text-primary">Tables</span></li><li><a role="button" data-toggle="collapse" ><span class="text-primary"><i class="glyphicon glyphicon-th-list"/> complex_table</span></a></li><li><a role="button" data-toggle="collapse" ><span class="text-primary"><i class="glyphicon glyphicon-th-list"/> sensor_data</span></a></li><li><a role="button" data-toggle="collapse" ><span class="text-primary"><i class="glyphicon glyphicon-th-list"/> stations</span></a></li><li role="separator" class="divider text-muted"></li><li class="dropdown-header"><span cla
ss="text-warning">User Defined Types</span></li><li><a role="button" data-toggle="collapse" ><span class="text-warning"><i class="glyphicon glyphicon-copyright-mark"/> address</span></a></li><li><a role="button" data-toggle="collapse" ><span class="text-warning"><i class="glyphicon glyphicon-copyright-mark"/> geolocation</span></a></li></ul></a></li><li><a><strong>DESCRIBE KEYSPACE live_data;</strong></a></li></ul><ul class="nav navbar-nav navbar-right"><li class="dropdown"><a class="dropdown-toggle" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false"><strong>Legend</strong><span class="caret"></span></a><ul class="dropdown-menu"><li><a role="button"><i class="glyphicon glyphicon-dashboard text-muted" /> Cluster</a></li><li><a role="button"><i class="glyphicon glyphicon-folder-open text-danger" /> Keyspace</a></li><li><a role="button"><i class="glyphicon glyphicon-copyright-mark text-warning" /> UDT</a></li><li><a role
="button"><i class="glyphicon glyphicon-th-list text-primary" /> Table</a></li><li><a role="button"><i class="glyphicon glyphicon-eye-open text-primary" /> Materialized View</a></li><li><a role="button"><i class="glyphicon glyphicon-random text-success" /> Function</a></li><li><a role="button"><i class="glyphicon glyphicon-retweet text-success" /> Aggregate</a></li><li role="separator" class="divider text-muted"></li><li class="dropdown-header"><span class="text-primary">Table icons</span></li><li class="bg-info"><a role="button"><i class="glyphicon glyphicon-fullscreen" /> Partition Key</a></li><li class="bg-warning"><a role="button"><i class="glyphicon glyphicon-pushpin" /> Static Column</a></li><li class="bg-success"><a role="button"><i class="glyphicon glyphicon-sort" /> Clustering Column</a></li><li class="bg-success"><a role="button"><i class="glyphicon glyphicon-sort-by-attributes" /> Clus
tering Order ASC</a></li><li class="bg-success"><a role="button"><i class="glyphicon glyphicon-sort-by-attributes-alt" /> Clustering Order DESC</a></li></ul></li><li><a href="#"></a></li></ul></nav><hr/><div class="container"><!-- Keyspace --><div class="row"><div class="col-md-2"></div><div class="col-md-8 col-offset-md-2"><div class="panel panel-default table-responsive table-bordered"><table class="table"><caption><h4 class="text-danger"><i class="glyphicon glyphicon-folder-open"/> live_data</h4></caption><thead><tr><th class="col-md-10">Replication</th><th class="col-md-2">Durable Writes</th></tr></thead><tbody><tr><td class="col-md-10">{'replication_factor' : '1', 'class' : 'org.apache.cassandra.locator.SimpleStrategy'}</td><td class="col-md-2">false</td></tr><tbody></table><div class="panel-footer"><a data-toggle="collapse" class="text-danger"><strong>As CQL statement</strong><span class="caret"></span></a><br/><br/><div class="collapse" ><pre class="wel
l">CREATE KEYSPACE live_data WITH REPLICATION = {'class' : 'org.apache.cassandra.locator.SimpleStrategy','replication_factor': '1' }AND DURABLE_WRITES = false;</pre></div></div></div></div><div class="col-md-2"></div></div><!-- Tables --><div class="row"></div><table width="100%"><td><hr /></td><td style="width:1px; padding: 0 10px; white-space: nowrap;"><strong class="text-primary">Tables</strong></td><td><hr /></td></table><div class="row"><div class="panel-group" role="tablist" aria-multiselectable="true"><div class="panel panel-default"><div class="panel-heading" role="tab"><h4 class="panel-title"><a role="button" data-toggle="collapse" aria-expanded="false"><span class="text-primary"><i class="glyphicon glyphicon-th-list"/> complex_table</span></a></h4></div><div class="panel-collapse collapse" role="tabpanel"><div class="panel-body"><div class="row"><div class="col-md-2"/><div class="col-md-8 col-offset-md-2"><div class="panel panel-default table-responsive table-border
ed"><table class="table"><thead><tr><th class="col-md-4">Column Type</th><th class="col-md-4">Column Name</th><th class="col-md-4">Data Type</th></tr></thead><tbody><tr class="info"><td class="col-md-4"><i class="glyphicon glyphicon-fullscreen" title="Partition Key"/></td><td class="col-md-4">pk1</td><td class="col-md-4">uuid</td></tr><tr class="info"><td class="col-md-4"><i class="glyphicon glyphicon-fullscreen" title="Partition Key"/></td><td class="col-md-4">pk2</td><td class="col-md-4">int</td></tr><tr class="warning"><td class="col-md-4"><i class="glyphicon glyphicon-pushpin" title="Static Column"/></td><td class="col-md-4">my_static1</td><td class="col-md-4">text</td></tr><tr class="warning"><td class="col-md-4"><i class="glyphicon glyphicon-pushpin" title="Static Column"/></td><td class="col-md-4">my_static2</td><td class="col-md-4">text</td></tr><tr class="success"><td class="col-md-4"><i class="glyphicon glyphicon-sort" title="Clustering Column"/> <i class="glyphicon g
lyphicon-sort-by-attributes-alt" title="Sort DESC"/></td><td class="col-md-4">clustering1</td><td class="col-md-4">timestamp</td></tr><tr class="success"><td class="col-md-4"><i class="glyphicon glyphicon-sort" title="Clustering Column"/> <i class="glyphicon glyphicon-sort-by-attributes" title="Sort ASC"/></td><td class="col-md-4">clustering2</td><td class="col-md-4">int</td></tr><tr class="success"><td class="col-md-4"><i class="glyphicon glyphicon-sort" title="Clustering Column"/> <i class="glyphicon glyphicon-sort-by-attributes-alt" title="Sort DESC"/></td><td class="col-md-4">clustering3</td><td class="col-md-4">text</td></tr><tr><td class="col-md-4"></td><td class="col-md-4">entries_indexed_map</td><td class="col-md-4">map<int, text></td></tr><tr><td class="col-md-4"></td><td class="col-md-4">indexed1</td><td class="col-md-4">text</td></tr><tr><td class="col-md-4"></td><td class="col-md-4">indexed2</td><td class="col-md-4">int</td></tr><tr><td class="col-md-4"><
/td><td class="col-md-4">key_indexed_map</td><td class="col-md-4">map<int, text></td></tr><tr><td class="col-md-4"></td><td class="col-md-4">my_list</td><td class="col-md-4">list<text></td></tr><tr><td class="col-md-4"></td><td class="col-md-4">my_map</td><td class="col-md-4">map<int, text></td></tr><tr><td class="col-md-4"></td><td class="col-md-4">my_udt</td><td class="col-md-4">frozen<live_data.address></td></tr><tr><td class="col-md-4"></td><td class="col-md-4">my_udt_list</td><td class="col-md-4">frozen<list<frozen<live_data.address>>></td></tr><tr><td class="col-md-4"></td><td class="col-md-4">simple</td><td class="col-md-4">double</td></tr></tbody></table><div class="panel-footer"><a data-toggle="collapse" class="text-primary"><strong>As CQL statement</strong><span class="caret"></span></a><br/><br/><div class="collapse" ><pre class="well">CREATE TABLE live_data.complex_table (pk1 uuid,pk2 int,clustering1 timestamp,clustering2 int,cl
ustering3 text,entries_indexed_map map<int, text>,indexed1 text,indexed2 int,key_indexed_map map<int, text>,my_list list<text>,my_map map<int, text>,my_static1 text static,my_static2 text static,my_udt frozen<live_data.address>,my_udt_list frozen<list<frozen<live_data.address>>>,simple double,PRIMARY KEY ((pk1, pk2), clustering1, clustering2, clustering3)) WITH CLUSTERING ORDER BY (clustering1 DESC, clustering2 ASC, clustering3 DESC)AND read_repair_chance = 0.0AND dclocal_read_repair_chance = 0.1AND gc_grace_seconds = 864000AND bloom_filter_fp_chance = 0.01AND caching = { 'keys' : 'ALL', 'rows_per_partition' : 'NONE' }AND comment = ''AND compaction = { 'class' : 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy' }AND compression = { 'sstable_compression' : 'org.apache.cassandra.io.compress.LZ4Compressor' }AND default_time_to_live = 0AND speculative_retry = '99.0PERCENTILE'AND min_index_interval = 128AND max_index_interva
l = 2048;</pre></div></div></div><hr/><div class="panel panel-default table-responsive table-bordered"><table class="table"><caption><h4 class="text-danger"><i class="glyphicon glyphicon-info-sign"/> complex_table's indices</h4></caption><thead><tr><th class="col-md-6">Name</th><th class="col-md-6">Target</th></tr></thead><tbody><tr><td class="col-md-6">clustering2idx</td><td class="col-md-6">clustering2</td></tr><tr><td class="col-md-6">idx1</td><td class="col-md-6">indexed1</td></tr><tr><td class="col-md-6">idx2</td><td class="col-md-6">indexed2</td></tr><tr><td class="col-md-6">keys_map_idx</td><td class="col-md-6">keys(key_indexed_map)</td></tr><tr><td class="col-md-6">pk2idx</td><td class="col-md-6">pk2</td></tr></tbody></table><div class="panel-footer"><a data-toggle="collapse" class="text-danger"><strong>As CQL statement</strong><span class="caret"></span></a><br/><br/><div class="collapse" ><pre class="well">CREATE INDEX clustering2idx ON live_data.complex_table (clust
ering2);CREATE INDEX idx1 ON live_data.complex_table (indexed1);CREATE INDEX idx2 ON live_data.complex_table (indexed2);CREATE INDEX keys_map_idx ON live_data.complex_table (keys(key_indexed_map));CREATE INDEX pk2idx ON live_data.complex_table (pk2);</pre></div></div></div></div><div class="col-md-2"></div></div></div></div></div><div class="panel panel-default"><div class="panel-heading" role="tab"><h4 class="panel-title"><a role="button" data-toggle="collapse" aria-expanded="false"><span class="text-primary"><i class="glyphicon glyphicon-th-list"/> sensor_data</span></a></h4></div><div class="panel-collapse collapse" role="tabpanel"><div class="panel-body"><div class="row"><div class="col-md-2"/><div class="col-md-8 col-offset-md-2"><div class="panel panel-default table-responsive table-bordered"><table class="table"><thead><tr><th class="col-md-4">Column Type</th><th class="col-md-4">Column Name</th><th class="col-md-4">Data Type</th></tr></thead><tbody><tr class="info"><t
d class="col-md-4"><i class="glyphicon glyphicon-fullscreen" title="Partition Key"/></td><td class="col-md-4">sensor_id</td><td class="col-md-4">uuid</td></tr><tr class="info"><td class="col-md-4"><i class="glyphicon glyphicon-fullscreen" title="Partition Key"/></td><td class="col-md-4">month</td><td class="col-md-4">int</td></tr><tr class="warning"><td class="col-md-4"><i class="glyphicon glyphicon-pushpin" title="Static Column"/></td><td class="col-md-4">characteristics</td><td class="col-md-4">map<text, text></td></tr><tr class="warning"><td class="col-md-4"><i class="glyphicon glyphicon-pushpin" title="Static Column"/></td><td class="col-md-4">model_number</td><td class="col-md-4">text</td></tr><tr class="warning"><td class="col-md-4"><i class="glyphicon glyphicon-pushpin" title="Static Column"/></td><td class="col-md-4">provider</td><td class="col-md-4">text</td></tr><tr class="success"><td class="col-md-4"><i class="glyphicon glyphicon-sort" title="Clustering Column"/>&n
bsp;<i class="glyphicon glyphicon-sort-by-attributes-alt" title="Sort DESC"/></td><td class="col-md-4">date</td><td class="col-md-4">timestamp</td></tr><tr><td class="col-md-4"></td><td class="col-md-4">value</td><td class="col-md-4">double</td></tr></tbody></table><div class="panel-footer"><a data-toggle="collapse" class="text-primary"><strong>As CQL statement</strong><span class="caret"></span></a><br/><br/><div class="collapse" ><pre class="well">CREATE TABLE live_data.sensor_data (sensor_id uuid,month int,date timestamp,characteristics map<text, text> static,model_number text static,provider text static,value double,PRIMARY KEY ((sensor_id, month), date)) WITH CLUSTERING ORDER BY (date DESC)AND read_repair_chance = 0.0AND dclocal_read_repair_chance = 0.1AND gc_grace_seconds = 864000AND bloom_filter_fp_chance = 0.01AND caching = { 'keys' : 'ALL', 'rows_per_partition' : 'NONE' }AND comment = ''AND compaction = { 'class' : 'org.apache.cassandra.db.compaction.SizeTieredCompac
tionStrategy' }AND compression = { 'sstable_compression' : 'org.apache.cassandra.io.compress.LZ4Compressor' }AND default_time_to_live = 0AND speculative_retry = '99.0PERCENTILE'AND min_index_interval = 128AND max_index_interval = 2048;</pre></div></div></div></div><div class="col-md-2"></div></div></div></div></div><div class="panel panel-default"><div class="panel-heading" role="tab"><h4 class="panel-title"><a role="button" data-toggle="collapse" aria-expanded="false"><span class="text-primary"><i class="glyphicon glyphicon-th-list"/> stations</span></a></h4></div><div class="panel-collapse collapse" role="tabpanel"><div class="panel-body"><div class="row"><div class="col-md-2"/><div class="col-md-8 col-offset-md-2"><div class="panel panel-default table-responsive table-bordered"><table class="table"><thead><tr><th class="col-md-4">Column Type</th><th class="col-md-4">Column Name</th><th class="col-md-4">Data Type</th></tr></thead><tbody><tr class="info"><td class="col-md-4"
><i class="glyphicon glyphicon-fullscreen" title="Partition Key"/></td><td class="col-md-4">station_id</td><td class="col-md-4">uuid</td></tr><tr><td class="col-md-4"></td><td class="col-md-4">sensors</td><td class="col-md-4">frozen<map<uuid, frozen<live_data.geolocation>>></td></tr></tbody></table><div class="panel-footer"><a data-toggle="collapse" class="text-primary"><strong>As CQL statement</strong><span class="caret"></span></a><br/><br/><div class="collapse" ><pre class="well">CREATE TABLE live_data.stations (station_id uuid,sensors frozen<map<uuid, frozen<live_data.geolocation>>>,PRIMARY KEY (station_id)) WITH read_repair_chance = 0.0AND dclocal_read_repair_chance = 0.1AND gc_grace_seconds = 864000AND bloom_filter_fp_chance = 0.01AND caching = { 'keys' : 'ALL', 'rows_per_partition' : 'NONE' }AND comment = ''AND compaction = { 'class' : 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy' }AND compression = { 'sstable_compressi
on' : 'org.apache.cassandra.io.compress.LZ4Compressor' }AND default_time_to_live = 0AND speculative_retry = '99.0PERCENTILE'AND min_index_interval = 128AND max_index_interval = 2048;</pre></div></div></div></div><div class="col-md-2"></div></div></div></div></div></div></div><!-- UDTs --><table width="100%"><td><hr /></td><td style="width:1px; padding: 0 10px; white-space: nowrap;"><strong class="text-warning">User Defined Types</strong></td><td><hr /></td></table><div class="row"><div class="panel-group" role="tablist" aria-multiselectable="true"><div class="panel panel-default"><div class="panel-heading" role="tab"><h4 class="panel-title"><a role="button" data-toggle="collapse" aria-expanded="false"><span class="text-warning"><i class="glyphicon glyphicon-copyright-mark"/> address</span></a></h4></div><div class="panel-collapse collapse" role="tabpanel"><div class="panel-body"><div class="row"><div class="col-md-3"></div><div class="col-md-6 col-offset-md-3"><div class="pan
el panel-default table-responsive table-bordered"><table class="table"><thead><tr><th class="col-md-6">Column Name</th><th class="col-md-6">Data Type</th></tr></thead><tbody><tr><td class="col-md-6">number</td><td class="col-md-6">int</td></tr><tr><td class="col-md-6">street</td><td class="col-md-6">text</td></tr><tr><td class="col-md-6">zip</td><td class="col-md-6">int</td></tr><tr><td class="col-md-6">city</td><td class="col-md-6">text</td></tr><tr><td class="col-md-6">country</td><td class="col-md-6">text</td></tr><tbody></table><div class="panel-footer"><a data-toggle="collapse" class="text-warning"><strong>As CQL statement</strong><span class="caret"></span></a><br/><br/><div class="collapse" ><pre class="well">CREATE TYPE live_data.address (number int,street text,zip int,city text,country text);</pre></div></div></div></div><div class="col-md-3"></div></div></div></div></div><div class="panel panel-default"><div class="panel-heading" role="tab"><h4 class="panel-title"><a role
="button" data-toggle="collapse" aria-expanded="false"><span class="text-warning"><i class="glyphicon glyphicon-copyright-mark"/> geolocation</span></a></h4></div><div class="panel-collapse collapse" role="tabpanel"><div class="panel-body"><div class="row"><div class="col-md-3"></div><div class="col-md-6 col-offset-md-3"><div class="panel panel-default table-responsive table-bordered"><table class="table"><thead><tr><th class="col-md-6">Column Name</th><th class="col-md-6">Data Type</th></tr></thead><tbody><tr><td class="col-md-6">latitude</td><td class="col-md-6">double</td></tr><tr><td class="col-md-6">longitude</td><td class="col-md-6">double</td></tr><tbody></table><div class="panel-footer"><a data-toggle="collapse" class="text-warning"><strong>As CQL statement</strong><span class="caret"></span></a><br/><br/><div class="collapse" ><pre class="well">CREATE TYPE live_data.geolocation (latitude double,longitude double);</pre></div></div></div></div><div class="col-md-3"></
div></div></div></div></div></div></div></div>
\ No newline at end of file