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)