asterixdb-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Glenn Marsh <bryan.ma...@email.ucr.edu>
Subject HTTP API / REST API query result not returning in JSON Format
Date Wed, 16 Sep 2015 00:27:33 GMT
For awhile I have been trying to create a wrapper around AsterixDB that
will add Transaction Time functionality without changing the code base for
AsterixDB.

The way have been able to do this is by making HTTP API/REST API  calls. In
Asterix version 0.8.5 when I would send a HTTP call in the form of a query
I would get back the result in a JSON format. Since switching to both
Asterix version 0.8.6 and the snapshot of 0.8.7, when making a HTTP call in
the form of a query the resultI get back is not in a JSON format.

Example:
Query: for $ds in dataset Metadata.Dataset return $ds;
URL encoded:
http://127.0.0.1:19002/query?query=for+%24ds+in+dataset+Metadata.Dataset+return+%24ds%3B%0A%0A%0A
Result:
<h4>Results:</h4>
<pre>
{ "DataverseName": "Metadata", "DatasetName": "CompactionPolicy",
"DataTypeName": "CompactionPolicyRecordType", "DatasetType": "INTERNAL",
"InternalDetails": { "FileStructure": "BTREE", "PartitioningStrategy":
"HASH", "PartitioningKey": [ "DataverseName", "CompactionPolicy" ],
"PrimaryKey": [ "DataverseName", "CompactionPolicy" ], "GroupName":
"MetadataGroup", "Autogenerated": false, "CompactionPolicy": "prefix",
"CompactionPolicyProperties": [ { "Name": "max-mergable-component-size",
"Value": "1073741824" }, { "Name": "max-tolerance-component-count",
"Value": "5" } ] }, "ExternalDetails": null, "Hints": {{  }}, "Timestamp":
"Tue Jul 07 23:18:17 PDT 2015", "DatasetId": 13, "PendingOp": 0 }
{ "DataverseName": "Metadata", "DatasetName": "Dataset", "DataTypeName":
"DatasetRecordType", "DatasetType": "INTERNAL", "InternalDetails": {
"FileStructure": "BTREE", "PartitioningStrategy": "HASH",
"PartitioningKey": [ "DataverseName", "DatasetName" ], "PrimaryKey": [
"DataverseName", "DatasetName" ], "GroupName": "MetadataGroup",
"Autogenerated": false, "CompactionPolicy": "prefix",
"CompactionPolicyProperties": [ { "Name": "max-mergable-component-size",
"Value": "1073741824" }, { "Name": "max-tolerance-component-count",
"Value": "5" } ] }, "ExternalDetails": null, "Hints": {{  }}, "Timestamp":
"Tue Jul 07 23:18:17 PDT 2015", "DatasetId": 2, "PendingOp": 0 }
{ "DataverseName": "Metadata", "DatasetName": "DatasourceAdapter",
"DataTypeName": "DatasourceAdapterRecordType", "DatasetType": "INTERNAL",
"InternalDetails": { "FileStructure": "BTREE", "PartitioningStrategy":
"HASH", "PartitioningKey": [ "DataverseName", "Name" ], "PrimaryKey": [
"DataverseName", "Name" ], "GroupName": "MetadataGroup", "Autogenerated":
false, "CompactionPolicy": "prefix", "CompactionPolicyProperties": [ {
"Name": "max-mergable-component-size", "Value": "1073741824" }, { "Name":
"max-tolerance-component-count", "Value": "5" } ] }, "ExternalDetails":
null, "Hints": {{  }}, "Timestamp": "Tue Jul 07 23:18:17 PDT 2015",
"DatasetId": 8, "PendingOp": 0 }
{ "DataverseName": "Metadata", "DatasetName": "Datatype", "DataTypeName":
"DatatypeRecordType", "DatasetType": "INTERNAL", "InternalDetails": {
"FileStructure": "BTREE", "PartitioningStrategy": "HASH",
"PartitioningKey": [ "DataverseName", "DatatypeName" ], "PrimaryKey": [
"DataverseName", "DatatypeName" ], "GroupName": "MetadataGroup",
"Autogenerated": false, "CompactionPolicy": "prefix",
"CompactionPolicyProperties": [ { "Name": "max-mergable-component-size",
"Value": "1073741824" }, { "Name": "max-tolerance-component-count",
"Value": "5" } ] }, "ExternalDetails": null, "Hints": {{  }}, "Timestamp":
"Tue Jul 07 23:18:17 PDT 2015", "DatasetId": 3, "PendingOp": 0 }
{ "DataverseName": "Metadata", "DatasetName": "Dataverse", "DataTypeName":
"DataverseRecordType", "DatasetType": "INTERNAL", "InternalDetails": {
"FileStructure": "BTREE", "PartitioningStrategy": "HASH",
"PartitioningKey": [ "DataverseName" ], "PrimaryKey": [ "DataverseName" ],
"GroupName": "MetadataGroup", "Autogenerated": false, "CompactionPolicy":
"prefix", "CompactionPolicyProperties": [ { "Name":
"max-mergable-component-size", "Value": "1073741824" }, { "Name":
"max-tolerance-component-count", "Value": "5" } ] }, "ExternalDetails":
null, "Hints": {{  }}, "Timestamp": "Tue Jul 07 23:18:17 PDT 2015",
"DatasetId": 1, "PendingOp": 0 }
{ "DataverseName": "Metadata", "DatasetName": "ExternalFile",
"DataTypeName": "ExternalFileRecordType", "DatasetType": "INTERNAL",
"InternalDetails": { "FileStructure": "BTREE", "PartitioningStrategy":
"HASH", "PartitioningKey": [ "DataverseName", "DatasetName", "FileNumber"
], "PrimaryKey": [ "DataverseName", "DatasetName", "FileNumber" ],
"GroupName": "MetadataGroup", "Autogenerated": false, "CompactionPolicy":
"prefix", "CompactionPolicyProperties": [ { "Name":
"max-mergable-component-size", "Value": "1073741824" }, { "Name":
"max-tolerance-component-count", "Value": "5" } ] }, "ExternalDetails":
null, "Hints": {{  }}, "Timestamp": "Tue Jul 07 23:18:17 PDT 2015",
"DatasetId": 14, "PendingOp": 0 }
{ "DataverseName": "Metadata", "DatasetName": "Feed", "DataTypeName":
"FeedRecordType", "DatasetType": "INTERNAL", "InternalDetails": {
"FileStructure": "BTREE", "PartitioningStrategy": "HASH",
"PartitioningKey": [ "DataverseName", "FeedName" ], "PrimaryKey": [
"DataverseName", "FeedName" ], "GroupName": "MetadataGroup",
"Autogenerated": false, "CompactionPolicy": "prefix",
"CompactionPolicyProperties": [ { "Name": "max-mergable-component-size",
"Value": "1073741824" }, { "Name": "max-tolerance-component-count",
"Value": "5" } ] }, "ExternalDetails": null, "Hints": {{  }}, "Timestamp":
"Tue Jul 07 23:18:17 PDT 2015", "DatasetId": 10, "PendingOp": 0 }
{ "DataverseName": "Metadata", "DatasetName": "FeedActivity",
"DataTypeName": "FeedActivityRecordType", "DatasetType": "INTERNAL",
"InternalDetails": { "FileStructure": "BTREE", "PartitioningStrategy":
"HASH", "PartitioningKey": [ "DataverseName", "FeedName", "DatasetName",
"ActivityId" ], "PrimaryKey": [ "DataverseName", "FeedName", "DatasetName",
"ActivityId" ], "GroupName": "MetadataGroup", "Autogenerated": false,
"CompactionPolicy": "prefix", "CompactionPolicyProperties": [ { "Name":
"max-mergable-component-size", "Value": "1073741824" }, { "Name":
"max-tolerance-component-count", "Value": "5" } ] }, "ExternalDetails":
null, "Hints": {{  }}, "Timestamp": "Tue Jul 07 23:18:17 PDT 2015",
"DatasetId": 11, "PendingOp": 0 }
{ "DataverseName": "Metadata", "DatasetName": "FeedPolicy", "DataTypeName":
"FeedPolicyRecordType", "DatasetType": "INTERNAL", "InternalDetails": {
"FileStructure": "BTREE", "PartitioningStrategy": "HASH",
"PartitioningKey": [ "DataverseName", "PolicyName" ], "PrimaryKey": [
"DataverseName", "PolicyName" ], "GroupName": "MetadataGroup",
"Autogenerated": false, "CompactionPolicy": "prefix",
"CompactionPolicyProperties": [ { "Name": "max-mergable-component-size",
"Value": "1073741824" }, { "Name": "max-tolerance-component-count",
"Value": "5" } ] }, "ExternalDetails": null, "Hints": {{  }}, "Timestamp":
"Tue Jul 07 23:18:17 PDT 2015", "DatasetId": 12, "PendingOp": 0 }
{ "DataverseName": "Metadata", "DatasetName": "Function", "DataTypeName":
"FunctionRecordType", "DatasetType": "INTERNAL", "InternalDetails": {
"FileStructure": "BTREE", "PartitioningStrategy": "HASH",
"PartitioningKey": [ "DataverseName", "Name", "Arity" ], "PrimaryKey": [
"DataverseName", "Name", "Arity" ], "GroupName": "MetadataGroup",
"Autogenerated": false, "CompactionPolicy": "prefix",
"CompactionPolicyProperties": [ { "Name": "max-mergable-component-size",
"Value": "1073741824" }, { "Name": "max-tolerance-component-count",
"Value": "5" } ] }, "ExternalDetails": null, "Hints": {{  }}, "Timestamp":
"Tue Jul 07 23:18:17 PDT 2015", "DatasetId": 7, "PendingOp": 0 }
{ "DataverseName": "Metadata", "DatasetName": "Index", "DataTypeName":
"IndexRecordType", "DatasetType": "INTERNAL", "InternalDetails": {
"FileStructure": "BTREE", "PartitioningStrategy": "HASH",
"PartitioningKey": [ "DataverseName", "DatasetName", "IndexName" ],
"PrimaryKey": [ "DataverseName", "DatasetName", "IndexName" ], "GroupName":
"MetadataGroup", "Autogenerated": false, "CompactionPolicy": "prefix",
"CompactionPolicyProperties": [ { "Name": "max-mergable-component-size",
"Value": "1073741824" }, { "Name": "max-tolerance-component-count",
"Value": "5" } ] }, "ExternalDetails": null, "Hints": {{  }}, "Timestamp":
"Tue Jul 07 23:18:17 PDT 2015", "DatasetId": 4, "PendingOp": 0 }
{ "DataverseName": "Metadata", "DatasetName": "Library", "DataTypeName":
"LibraryRecordType", "DatasetType": "INTERNAL", "InternalDetails": {
"FileStructure": "BTREE", "PartitioningStrategy": "HASH",
"PartitioningKey": [ "DataverseName", "Name" ], "PrimaryKey": [
"DataverseName", "Name" ], "GroupName": "MetadataGroup", "Autogenerated":
false, "CompactionPolicy": "prefix", "CompactionPolicyProperties": [ {
"Name": "max-mergable-component-size", "Value": "1073741824" }, { "Name":
"max-tolerance-component-count", "Value": "5" } ] }, "ExternalDetails":
null, "Hints": {{  }}, "Timestamp": "Tue Jul 07 23:18:17 PDT 2015",
"DatasetId": 9, "PendingOp": 0 }
{ "DataverseName": "Metadata", "DatasetName": "Node", "DataTypeName":
"NodeRecordType", "DatasetType": "INTERNAL", "InternalDetails": {
"FileStructure": "BTREE", "PartitioningStrategy": "HASH",
"PartitioningKey": [ "NodeName" ], "PrimaryKey": [ "NodeName" ],
"GroupName": "MetadataGroup", "Autogenerated": false, "CompactionPolicy":
"prefix", "CompactionPolicyProperties": [ { "Name":
"max-mergable-component-size", "Value": "1073741824" }, { "Name":
"max-tolerance-component-count", "Value": "5" } ] }, "ExternalDetails":
null, "Hints": {{  }}, "Timestamp": "Tue Jul 07 23:18:17 PDT 2015",
"DatasetId": 5, "PendingOp": 0 }
{ "DataverseName": "Metadata", "DatasetName": "Nodegroup", "DataTypeName":
"NodeGroupRecordType", "DatasetType": "INTERNAL", "InternalDetails": {
"FileStructure": "BTREE", "PartitioningStrategy": "HASH",
"PartitioningKey": [ "GroupName" ], "PrimaryKey": [ "GroupName" ],
"GroupName": "MetadataGroup", "Autogenerated": false, "CompactionPolicy":
"prefix", "CompactionPolicyProperties": [ { "Name":
"max-mergable-component-size", "Value": "1073741824" }, { "Name":
"max-tolerance-component-count", "Value": "5" } ] }, "ExternalDetails":
null, "Hints": {{  }}, "Timestamp": "Tue Jul 07 23:18:17 PDT 2015",
"DatasetId": 6, "PendingOp": 0 }
</pre>

The formatting seems to be that of HTML and not JSON.

Due to time restrictions, I am being forced to write my own parser to be
able to parse feedback from HTTP API calls. But I am wondering is this a
bug or is this the new intended behavior of the HTTP API calls. I think its
the former due to the documentation and the way the calls used to work in
the past.

Thank you for your time.

Mime
View raw message