Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
--get storage plugins
curl http://node3.mapr.com:8047/storage.json
--create storage plugin
curl --request POST --header "ContentType: application/json" --data '{"name": "dfs1", "config": { "type": "file", "enabled": false, "connection": "maprfs:///", "workspaces": null, "formats": null }}' http://node3.mapr.com:8047/storage/dfs1.json
{
"result" : "success"
}
--get specific storage plugin
curl http://10.10.71.14:8047/storage/dfs1.json
{
"name" : "dfs1",
"config" : {
"type" : "file",
"enabled" : false,
"connection" : "maprfs:///",
"workspaces" : null,
"formats" : null
}
}
--enable storage plugin
curl http://10.10.71.14:8047/storage/dfs1/enable/true
{
"result" : "success"
}
--delete storage plugin
curl --request DELETE http://node3.mapr.com:8047/storage/dfs1.json
{
"result" : "success"
}
--run a query
$curl --header "Content-Type:application/json" --request POST --data '{"queryType":"sql","query":"select * from cp.`employee.json` limit 1"}' http://node3.mapr.com:8047/query.json
{
"columns" : [ "employee_id", "full_name", "first_name", "last_name", "position_id", "position_title", "store_id", "department_id", "birth_date", "hire_date", "salary", "supervisor_id", "education_level", "marital_status", "gender", "management_role" ],
"rows" : [ {
"hire_date" : "1994-12-01 00:00:00.0",
"birth_date" : "1961-08-26",
"department_id" : "1",
"store_id" : "0",
"education_level" : "Graduate Degree",
"first_name" : "Sheri",
"position_id" : "1",
"management_role" : "Senior Management",
"last_name" : "Nowmer",
"gender" : "F",
"position_title" : "President",
"marital_status" : "S",
"salary" : "80000.0",
"employee_id" : "1",
"supervisor_id" : "0",
"full_name" : "Sheri Nowmer"
} ]
--look profiles of running as well as completed query
curl http://node3.mapr.com:8047/profiles.json
{
"runningQueries" : [ ],
"finishedQueries" : [ {
"queryId" : "29e04874-ac9a-d342-a531-94026c60a23d",
"time" : "10/15/2015 19:56:18",
"location" : "http://localhost:8047/profile/29e04874-ac9a-d342-a531-94026c60a23d.json",
"foreman" : "node3.mapr.com",
"query" : "select * from cp.`employee.json` limit 1",
"state" : "COMPLETED",
"user" : "anonymous"
}
}
-- Access specific profile
curl http://node3.mapr.com:8047/profiles/29e04874-ac9a-d342-a531-94026c60a23d.json
{"id":{"part1":3017491416287466306,"part2":-6543286045463502275},"type":1,"start":1444919178129,"end":1444919178477,"query":"select * from cp.`employee.json` limit 1","plan":"00-00 Screen : rowType = RecordType(ANY *): rowcount = 1.0, cumulative cost = {465.1 rows, 468.1 cpu, 0.0 io, 0.0 network, 0.0 memory}, id = 319\n00-01 Project(*=[$0]) : rowType = RecordType(ANY *): rowcount = 1.0, cumulative cost = {465.0 rows, 468.0 cpu, 0.0 io, 0.0 network, 0.0 memory}, id = 318\n00-02 SelectionVectorRemover : rowType = (DrillRecordRow[*]): rowcount = 1.0, cumulative cost = {465.0 rows, 468.0 cpu, 0.0 io, 0.0 network, 0.0 memory}, id = 317\n00-03 Limit(fetch=[1]) : rowType = (DrillRecordRow[*]): rowcount = 1.0, cumulative cost = {464.0 rows, 467.0 cpu, 0.0 io, 0.0 network, 0.0 memory}, id = 316\n00-04 Scan(groupscan=[EasyGroupScan [selectionRoot=classpath:/employee.json, numFiles=1, columns=[`*`], files=[classpath:/employee.json]]]) : rowType = (DrillRecordRow[*]): rowcount = 463.0, cumulative cost = {463.0 rows, 463.0 cpu, 0.0 io, 0.0 network, 0.0 memory}, id = 315\n","foreman":{"address":"node3.mapr.com","userPort":31010,"controlPort":31011,"dataPort":31012},"state":2,"totalFragments":1,"finishedFragments":0,"fragmentProfile":[{"majorFragmentId":0,"minorFragmentProfile":[{"state":3,"minorFragmentId":0,"operatorProfile":[{"inputProfile":[{"records":1155,"batches":1,"schemas":1}],"operatorId":4,"operatorType":29,"setupNanos":0,"processNanos":218248339,"peakLocalMemoryAllocated":753664,"waitNanos":257759},{"inputProfile":[{"records":1155,"batches":1,"schemas":1}],"operatorId":3,"operatorType":7,"setupNanos":652445,"processNanos":307592,"peakLocalMemoryAllocated":2310,"waitNanos":0},{"inputProfile":[{"records":1,"batches":1,"schemas":1}],"operatorId":2,"operatorType":14,"setupNanos":18696165,"processNanos":1823045,"peakLocalMemoryAllocated":532540,"waitNanos":0},{"inputProfile":[{"records":1,"batches":1,"schemas":1}],"operatorId":1,"operatorType":10,"setupNanos":1453550,"processNanos":521909,"peakLocalMemoryAllocated":0,"waitNanos":0},{"inputProfile":[{"records":1,"batches":1,"schemas":1}],"operatorId":0,"operatorType":13,"setupNanos":0,"processNanos":1394229,"peakLocalMemoryAllocated":0,"metric":[{"metricId":0,"longValue":241}],"waitNanos":9035099}],"startTime":1444919178215,"endTime":1444919178473,"memoryUsed":0,"maxMemoryUsed":5000256,"endpoint":{"address":"node3.mapr.com","userPort":31010,"controlPort":31011,"dataPort":31012},"lastUpdate":1444919178474,"lastProgress":1444919178474}]}],"user":"anonymous"}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment