Details
-
Bug
-
Resolution: Fixed
-
Major
-
Morpheus
-
7.5.0-4355
-
Untriaged
-
Linux x86_64
-
0
-
Unknown
-
Analytics Sprint 20
Description
Metadata "DatasetFormat" is missing for datasets created without specifying storage format.
Steps to reproduce -
- Create a cluster which has atleast 1 cbas node.
- Load travel-sample bucket.
- now change storage format to column using analytics/config/service endpoint.
- now created dataset as below -
create dataset x on `travel-sample`;
|
5. Check metadata.
[
|
{
|
"Dataset": { |
"DataverseName": "Default", |
"DatasetName": "x", |
"DatatypeDataverseName": "Metadata", |
"DatatypeName": "AnyObject", |
"DatasetType": "INTERNAL", |
"GroupName": "Default.x", |
"CompactionPolicy": "concurrent", |
"CompactionPolicyProperties": [ |
{
|
"Name": "max-component-count", |
"Value": "30" |
},
|
{
|
"Name": "min-merge-component-count", |
"Value": "3" |
},
|
{
|
"Name": "max-merge-component-count", |
"Value": "10" |
},
|
{
|
"Name": "size-ratio", |
"Value": "1.2" |
}
|
],
|
"InternalDetails": { |
"FileStructure": "BTREE", |
"PartitioningStrategy": "HASH", |
"PartitioningKey": [ |
[
|
"id" |
]
|
],
|
"PrimaryKey": [ |
[
|
"id" |
]
|
],
|
"Autogenerated": false, |
"KeySourceIndicator": [ |
1 |
]
|
},
|
"Hints": [], |
"Timestamp": "Wed May 17 08:04:58 UTC 2023", |
"DatasetId": 107, |
"PendingOp": 0, |
"MetatypeDataverseName": "Metadata", |
"MetatypeName": "DCPMeta", |
"BlockLevelStorageCompression": { |
"DatasetCompressionScheme": "snappy" |
},
|
"BucketDataverseName": "Default", |
"LinkName": "Local", |
"BucketName": "travel-sample", |
"ScopeName": "_default", |
"CollectionName": "_default", |
"CollectionId": "0" |
}
|
}
|
]
|
6. But if we create dataset as below -
CREATE ANALYTICS COLLECTION airport_col
|
WITH { "storage-format": {"format" : "column"} } |
ON `travel-sample`.inventory.airport;
|
7. Check metadata.
[
|
{
|
"Dataset": { |
"DataverseName": "Default", |
"DatasetName": "airport_col", |
"DatatypeDataverseName": "Metadata", |
"DatatypeName": "AnyObject", |
"DatasetType": "INTERNAL", |
"GroupName": "Default.airport_col", |
"CompactionPolicy": "concurrent", |
"CompactionPolicyProperties": [ |
{
|
"Name": "max-component-count", |
"Value": "30" |
},
|
{
|
"Name": "min-merge-component-count", |
"Value": "3" |
},
|
{
|
"Name": "max-merge-component-count", |
"Value": "10" |
},
|
{
|
"Name": "size-ratio", |
"Value": "1.2" |
}
|
],
|
"InternalDetails": { |
"FileStructure": "BTREE", |
"PartitioningStrategy": "HASH", |
"PartitioningKey": [ |
[
|
"id" |
]
|
],
|
"PrimaryKey": [ |
[
|
"id" |
]
|
],
|
"Autogenerated": false, |
"KeySourceIndicator": [ |
1 |
]
|
},
|
"Hints": [], |
"Timestamp": "Wed May 17 08:02:05 UTC 2023", |
"DatasetId": 106, |
"PendingOp": 0, |
"MetatypeDataverseName": "Metadata", |
"MetatypeName": "DCPMeta", |
"BlockLevelStorageCompression": { |
"DatasetCompressionScheme": "snappy" |
},
|
"DatasetFormat": { |
"Format": "COLUMN", |
"MaxTupleCount": 15000, |
"FreeSpaceTolerance": 0.15000000596046448 |
},
|
"BucketDataverseName": "Default", |
"LinkName": "Local", |
"BucketName": "travel-sample", |
"ScopeName": "inventory", |
"CollectionName": "airport", |
"CollectionId": "13" |
}
|
}
|
]
|
8. Also creating dataset with storage format as row.
CREATE ANALYTICS COLLECTION airport_row WITH { "storage-format": {"format" : "row"} } ON `travel-sample`.inventory.airport; |
9. DatasetFormat is missing from Metadata.
{
|
"Dataset": { |
"DataverseName": "Default", |
"DatasetName": "airport_row", |
"DatatypeDataverseName": "Metadata", |
"DatatypeName": "AnyObject", |
"DatasetType": "INTERNAL", |
"GroupName": "Default.airport_row", |
"CompactionPolicy": "concurrent", |
"CompactionPolicyProperties": [ |
{
|
"Name": "max-component-count", |
"Value": "30" |
},
|
{
|
"Name": "min-merge-component-count", |
"Value": "3" |
},
|
{
|
"Name": "max-merge-component-count", |
"Value": "10" |
},
|
{
|
"Name": "size-ratio", |
"Value": "1.2" |
}
|
],
|
"InternalDetails": { |
"FileStructure": "BTREE", |
"PartitioningStrategy": "HASH", |
"PartitioningKey": [ |
[
|
"id" |
]
|
],
|
"PrimaryKey": [ |
[
|
"id" |
]
|
],
|
"Autogenerated": false, |
"KeySourceIndicator": [ |
1 |
]
|
},
|
"Hints": [], |
"Timestamp": "Wed May 17 08:17:20 UTC 2023", |
"DatasetId": 108, |
"PendingOp": 0, |
"MetatypeDataverseName": "Metadata", |
"MetatypeName": "DCPMeta", |
"BlockLevelStorageCompression": { |
"DatasetCompressionScheme": "snappy" |
},
|
"BucketDataverseName": "Default", |
"LinkName": "Local", |
"BucketName": "travel-sample", |
"ScopeName": "inventory", |
"CollectionName": "airport", |
"CollectionId": "13" |
}
|
}
|
Suggestion -
Metadata should be consistent.
Attachments
Issue Links
- links to
For Gerrit Dashboard: MB-56967 | ||||||
---|---|---|---|---|---|---|
# | Subject | Branch | Project | Status | CR | V |
191313,2 | [MB-56967] Add DatasetFormat in Metadata.Dataset | master | cbas-core | Status: MERGED | +2 | +1 |