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"/>&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' : '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' : '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' : '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' : '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)

Reply via email to