[ZEPPELIN-4355] CassandraInterpreterTest fails

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.9.0
• Fix Version/s: 0.9.0
• Assignee: Lee Moon Soo
• Reporter: Jeff Zhang
• Created: 27/Sep/19 07:03
• Updated: 24/Dec/20 03:15
• Resolved: 01/Oct/19 20:07

Description

 

https://api.travis-ci.org/v3/job/590224518/log.txt

 

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"/>&nbsp;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"/>&nbsp;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&lt;text, text&gt;</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"/>&nbsp;<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&lt;text, text&gt; 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&lt;span class="code-quote">' : '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"/>&nbsp;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&lt;map&lt;uuid, frozen&lt;live_data.geolocation&gt;&gt;&gt;</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&lt;map&lt;uuid, frozen&lt;live_data.geolocation&gt;&gt;&gt;,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&lt;span class="code-quote">' : '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"/>&nbsp;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"/>&nbsp;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&lt;text, text&gt;</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"/>&nbsp;<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&lt;text, text&gt; 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&lt;span class="code-quote">' : '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"/>&nbsp;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&lt;map&lt;uuid, frozen&lt;live_data.geolocation&gt;&gt;&gt;</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&lt;map&lt;uuid, frozen&lt;live_data.geolocation&gt;&gt;&gt;,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&lt;span class="code-quote">' : '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><...>  

Issue Links

• duplicates: ZEPPELIN-4352 Test fail after ZEPPELIN-4331
• links to: GitHub Pull Request #3465
• links to: GitHub Pull Request #3469