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 Re: HTTP API / REST API query result not returning in JSON Format
Date Wed, 16 Sep 2015 04:44:10 GMT
What I have been using till now was 'application/json and have changed it
to application/x-adm  like you suggested and I am still getting the same
results as described above.



On Tue, Sep 15, 2015 at 5:34 PM, Ian Maxon <imaxon@uci.edu> wrote:

> Hi Bryan,
>
> The change that happened between those versions was the addition of
> output format specification based on the Accept header. There
> shouldn't be any necessity to hacking apart that HTML output to
> extract the ADM within. Are your accept headers for HTTP? You should
> be able to get the same output you had in 0.8.5 by requesting
> application/x-adm instead.
>
> Thanks,
> -Ian
>
> On Tue, Sep 15, 2015 at 5:27 PM, Bryan Glenn Marsh
> <bryan.marsh@email.ucr.edu> wrote:
> > 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