You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@zeppelin.apache.org by "Jeff Zhang (Jira)" <ji...@apache.org> on 2019/09/27 07:04:00 UTC
[jira] [Created] (ZEPPELIN-4355) CassandraInterpreterTest fails
Jeff Zhang created ZEPPELIN-4355:
------------------------------------
Summary: CassandraInterpreterTest fails
Key: ZEPPELIN-4355
URL: https://issues.apache.org/jira/browse/ZEPPELIN-4355
Project: Zeppelin
Issue Type: Improvement
Affects Versions: 0.9.0
Reporter: Jeff Zhang
{code:java}
Failed tests: CassandraInterpreterTest.should_describe_table:693 expected:<...ndex_interval = 2048[];</pre></div></div><...> but was:<...ndex_interval = 2048[AND memtable_flush_period_in_ms = 0];</pre></div></div><...> CassandraInterpreterTest.should_describe_keyspace:609 expected:<...ndex_interval = 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 (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));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"><td 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"/> <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.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_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_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><...> but was:<...ndex_interval = 2048[AND memtable_flush_period_in_ms = 0;</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 (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));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"><td 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"/> <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.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_interval = 2048AND memtable_flush_period_in_ms = 0;</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_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 = 2048AND memtable_flush_period_in_ms = 0];</pre></div></div><...> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)