banks.json

{"paragraphs":[{"text":"import org.apache.commons.io.IOUtils\nimport java.net.URL\nimport java.nio.charset.Charset\n\n// Zeppelin creates and injects sc (SparkContext) and sqlContext (HiveContext or SqlContext)\n// So you don't need create them manually\n\n// load bank data\nval bankText = sc.parallelize(\n    IOUtils.toString(\n        new URL(\"https://s3.amazonaws.com/apache-zeppelin/tutorial/bank/bank-full.csv\"),\n        Charset.forName(\"utf8\")).split(\"\\n\"))\n\ncase class Bank(age: Integer, job: String, marital: String, education: String, balance: Integer)\n\nval bank = bankText.map(s => s.split(\";\")).filter(s => s(0) != \"\\\"age\\\"\").map(\n    s => Bank(s(0).toInt, \n            s(1).replaceAll(\"\\\"\", \"\"),\n            s(2).replaceAll(\"\\\"\", \"\"),\n            s(3).replaceAll(\"\\\"\", \"\"),\n            s(5).replaceAll(\"\\\"\", \"\").toInt\n        )\n).toDF()\nbank.registerTempTable(\"bank\")","dateUpdated":"2016-06-28T11:13:53+0000","config":{"colWidth":12,"graph":{"mode":"table","height":300,"optionOpen":false,"keys":[],"values":[],"groups":[],"scatter":{}},"enabled":true,"editorMode":"ace/mode/scala"},"settings":{"params":{},"forms":{}},"jobName":"paragraph_1467110200901_-272597361","id":"20160628-103640_1343365132","result":{"code":"SUCCESS","type":"TEXT","msg":"import org.apache.commons.io.IOUtils\nimport java.net.URL\nimport java.nio.charset.Charset\nbankText: org.apache.spark.rdd.RDD[String] = ParallelCollectionRDD[151] at parallelize at <console>:44\ndefined class Bank\nbank: org.apache.spark.sql.DataFrame = [age: int, job: string, marital: string, education: string, balance: int]\n"},"dateCreated":"2016-06-28T10:36:40+0000","dateStarted":"2016-06-28T11:13:54+0000","dateFinished":"2016-06-28T11:14:00+0000","status":"FINISHED","progressUpdateIntervalMs":500,"$$hashKey":"object:199"},{"text":"%sql \nselect age, count(1) value\nfrom bank \nwhere age < 30 \ngroup by age \norder by age","dateUpdated":"2016-06-28T11:16:59+0000","config":{"colWidth":4,"graph":{"mode":"multiBarChart","height":300,"optionOpen":false,"keys":[{"name":"age","index":0,"aggr":"sum"}],"values":[{"name":"value","index":1,"aggr":"sum"}],"groups":[],"scatter":{"xAxis":{"name":"age","index":0,"aggr":"sum"},"yAxis":{"name":"value","index":1,"aggr":"sum"}}},"enabled":true,"editorMode":"ace/mode/sql"},"settings":{"params":{},"forms":{}},"jobName":"paragraph_1467110208798_1194850268","id":"20160628-103648_776194461","result":{"code":"SUCCESS","type":"TABLE","msg":"age\tvalue\n18\t12\n19\t35\n20\t50\n21\t79\n22\t129\n23\t202\n24\t302\n25\t527\n26\t805\n27\t909\n28\t1038\n29\t1185\n","comment":"","msgTable":[[{"key":"value","value":"18"},{"key":"value","value":"12"}],[{"value":"19"},{"value":"35"}],[{"value":"20"},{"value":"50"}],[{"value":"21"},{"value":"79"}],[{"value":"22"},{"value":"129"}],[{"value":"23"},{"value":"202"}],[{"value":"24"},{"value":"302"}],[{"value":"25"},{"value":"527"}],[{"value":"26"},{"value":"805"}],[{"value":"27"},{"value":"909"}],[{"value":"28"},{"value":"1038"}],[{"value":"29"},{"value":"1185"}]],"columnNames":[{"name":"age","index":0,"aggr":"sum"},{"name":"value","index":1,"aggr":"sum"}],"rows":[["18","12"],["19","35"],["20","50"],["21","79"],["22","129"],["23","202"],["24","302"],["25","527"],["26","805"],["27","909"],["28","1038"],["29","1185"]]},"dateCreated":"2016-06-28T10:36:48+0000","dateStarted":"2016-06-28T11:16:48+0000","dateFinished":"2016-06-28T11:16:52+0000","status":"FINISHED","progressUpdateIntervalMs":500,"$$hashKey":"object:200","focus":true},{"text":"%sql \nselect age, count(1) value \nfrom bank \nwhere age < ${maxAge=30} \ngroup by age \norder by age","dateUpdated":"2016-06-28T11:17:42+0000","config":{"colWidth":4,"graph":{"mode":"multiBarChart","height":300,"optionOpen":false,"keys":[{"name":"age","index":0,"aggr":"sum"}],"values":[{"name":"value","index":1,"aggr":"sum"}],"groups":[],"scatter":{"xAxis":{"name":"age","index":0,"aggr":"sum"},"yAxis":{"name":"value","index":1,"aggr":"sum"}}},"enabled":true,"editorMode":"ace/mode/sql"},"settings":{"params":{"maxAge":"50"},"forms":{"maxAge":{"name":"maxAge","defaultValue":"30","hidden":false}}},"jobName":"paragraph_1467110270958_-1126816540","id":"20160628-103750_829908762","result":{"code":"SUCCESS","type":"TABLE","msg":"age\tvalue\n18\t12\n19\t35\n20\t50\n21\t79\n22\t129\n23\t202\n24\t302\n25\t527\n26\t805\n27\t909\n28\t1038\n29\t1185\n30\t1757\n31\t1996\n32\t2085\n33\t1972\n34\t1930\n35\t1894\n36\t1806\n37\t1696\n38\t1466\n39\t1487\n40\t1355\n41\t1291\n42\t1242\n43\t1161\n44\t1136\n45\t1216\n46\t1175\n47\t1088\n48\t997\n49\t994\n","comment":"","msgTable":[[{"key":"value","value":"18"},{"key":"value","value":"12"}],[{"value":"19"},{"value":"35"}],[{"value":"20"},{"value":"50"}],[{"value":"21"},{"value":"79"}],[{"value":"22"},{"value":"129"}],[{"value":"23"},{"value":"202"}],[{"value":"24"},{"value":"302"}],[{"value":"25"},{"value":"527"}],[{"value":"26"},{"value":"805"}],[{"value":"27"},{"value":"909"}],[{"value":"28"},{"value":"1038"}],[{"value":"29"},{"value":"1185"}],[{"value":"30"},{"value":"1757"}],[{"value":"31"},{"value":"1996"}],[{"value":"32"},{"value":"2085"}],[{"value":"33"},{"value":"1972"}],[{"value":"34"},{"value":"1930"}],[{"value":"35"},{"value":"1894"}],[{"value":"36"},{"value":"1806"}],[{"value":"37"},{"value":"1696"}],[{"value":"38"},{"value":"1466"}],[{"value":"39"},{"value":"1487"}],[{"value":"40"},{"value":"1355"}],[{"value":"41"},{"value":"1291"}],[{"value":"42"},{"value":"1242"}],[{"value":"43"},{"value":"1161"}],[{"value":"44"},{"value":"1136"}],[{"value":"45"},{"value":"1216"}],[{"value":"46"},{"value":"1175"}],[{"value":"47"},{"value":"1088"}],[{"value":"48"},{"value":"997"}],[{"value":"49"},{"value":"994"}]],"columnNames":[{"name":"age","index":0,"aggr":"sum"},{"name":"value","index":1,"aggr":"sum"}],"rows":[["18","12"],["19","35"],["20","50"],["21","79"],["22","129"],["23","202"],["24","302"],["25","527"],["26","805"],["27","909"],["28","1038"],["29","1185"],["30","1757"],["31","1996"],["32","2085"],["33","1972"],["34","1930"],["35","1894"],["36","1806"],["37","1696"],["38","1466"],["39","1487"],["40","1355"],["41","1291"],["42","1242"],["43","1161"],["44","1136"],["45","1216"],["46","1175"],["47","1088"],["48","997"],["49","994"]]},"dateCreated":"2016-06-28T10:37:50+0000","dateStarted":"2016-06-28T11:17:42+0000","dateFinished":"2016-06-28T11:17:45+0000","status":"FINISHED","progressUpdateIntervalMs":500,"$$hashKey":"object:201","focus":true},{"text":"%sql \nselect age, count(1) value \nfrom bank \nwhere marital=\"${marital=single,single|divorced|married}\" \ngroup by age ","dateUpdated":"2016-06-28T11:18:09+0000","config":{"colWidth":4,"graph":{"mode":"multiBarChart","height":300,"optionOpen":false,"keys":[{"name":"age","index":0,"aggr":"sum"}],"values":[{"name":"value","index":1,"aggr":"sum"}],"groups":[],"scatter":{"xAxis":{"name":"age","index":0,"aggr":"sum"},"yAxis":{"name":"value","index":1,"aggr":"sum"}}},"enabled":true,"editorMode":"ace/mode/sql"},"settings":{"params":{"marital":"married"},"forms":{"marital":{"name":"marital","defaultValue":"single","options":[{"value":"single","$$hashKey":"object:1205"},{"value":"divorced","$$hashKey":"object:1206"},{"value":"married","$$hashKey":"object:1207"}],"hidden":false}}},"jobName":"paragraph_1467110311446_192163986","id":"20160628-103831_1795588676","result":{"code":"SUCCESS","type":"TABLE","msg":"age\tvalue\n31\t881\n32\t1007\n33\t1075\n34\t1131\n35\t1077\n36\t1076\n37\t1073\n38\t905\n39\t960\n40\t929\n41\t875\n42\t840\n43\t805\n44\t782\n45\t893\n46\t852\n47\t826\n48\t707\n49\t733\n50\t699\n51\t710\n52\t699\n53\t657\n54\t579\n55\t589\n56\t564\n57\t642\n58\t584\n59\t583\n60\t465\n61\t123\n62\t74\n63\t68\n64\t65\n65\t50\n66\t53\n67\t43\n68\t26\n69\t34\n70\t53\n71\t42\n72\t44\n73\t36\n74\t32\n75\t27\n76\t24\n77\t38\n78\t18\n79\t17\n80\t29\n81\t9\n82\t10\n83\t12\n84\t6\n85\t4\n86\t6\n87\t3\n88\t2\n89\t2\n92\t2\n93\t2\n95\t1\n20\t3\n21\t5\n22\t9\n23\t27\n24\t53\n25\t98\n26\t170\n27\t233\n28\t325\n29\t463\n30\t675\n","comment":"","msgTable":[[{"key":"value","value":"31"},{"key":"value","value":"881"}],[{"value":"32"},{"value":"1007"}],[{"value":"33"},{"value":"1075"}],[{"value":"34"},{"value":"1131"}],[{"value":"35"},{"value":"1077"}],[{"value":"36"},{"value":"1076"}],[{"value":"37"},{"value":"1073"}],[{"value":"38"},{"value":"905"}],[{"value":"39"},{"value":"960"}],[{"value":"40"},{"value":"929"}],[{"value":"41"},{"value":"875"}],[{"value":"42"},{"value":"840"}],[{"value":"43"},{"value":"805"}],[{"value":"44"},{"value":"782"}],[{"value":"45"},{"value":"893"}],[{"value":"46"},{"value":"852"}],[{"value":"47"},{"value":"826"}],[{"value":"48"},{"value":"707"}],[{"value":"49"},{"value":"733"}],[{"value":"50"},{"value":"699"}],[{"value":"51"},{"value":"710"}],[{"value":"52"},{"value":"699"}],[{"value":"53"},{"value":"657"}],[{"value":"54"},{"value":"579"}],[{"value":"55"},{"value":"589"}],[{"value":"56"},{"value":"564"}],[{"value":"57"},{"value":"642"}],[{"value":"58"},{"value":"584"}],[{"value":"59"},{"value":"583"}],[{"value":"60"},{"value":"465"}],[{"value":"61"},{"value":"123"}],[{"value":"62"},{"value":"74"}],[{"value":"63"},{"value":"68"}],[{"value":"64"},{"value":"65"}],[{"value":"65"},{"value":"50"}],[{"value":"66"},{"value":"53"}],[{"value":"67"},{"value":"43"}],[{"value":"68"},{"value":"26"}],[{"value":"69"},{"value":"34"}],[{"value":"70"},{"value":"53"}],[{"value":"71"},{"value":"42"}],[{"value":"72"},{"value":"44"}],[{"value":"73"},{"value":"36"}],[{"value":"74"},{"value":"32"}],[{"value":"75"},{"value":"27"}],[{"value":"76"},{"value":"24"}],[{"value":"77"},{"value":"38"}],[{"value":"78"},{"value":"18"}],[{"value":"79"},{"value":"17"}],[{"value":"80"},{"value":"29"}],[{"value":"81"},{"value":"9"}],[{"value":"82"},{"value":"10"}],[{"value":"83"},{"value":"12"}],[{"value":"84"},{"value":"6"}],[{"value":"85"},{"value":"4"}],[{"value":"86"},{"value":"6"}],[{"value":"87"},{"value":"3"}],[{"value":"88"},{"value":"2"}],[{"value":"89"},{"value":"2"}],[{"value":"92"},{"value":"2"}],[{"value":"93"},{"value":"2"}],[{"value":"95"},{"value":"1"}],[{"value":"20"},{"value":"3"}],[{"value":"21"},{"value":"5"}],[{"value":"22"},{"value":"9"}],[{"value":"23"},{"value":"27"}],[{"value":"24"},{"value":"53"}],[{"value":"25"},{"value":"98"}],[{"value":"26"},{"value":"170"}],[{"value":"27"},{"value":"233"}],[{"value":"28"},{"value":"325"}],[{"value":"29"},{"value":"463"}],[{"value":"30"},{"value":"675"}]],"columnNames":[{"name":"age","index":0,"aggr":"sum"},{"name":"value","index":1,"aggr":"sum"}],"rows":[["31","881"],["32","1007"],["33","1075"],["34","1131"],["35","1077"],["36","1076"],["37","1073"],["38","905"],["39","960"],["40","929"],["41","875"],["42","840"],["43","805"],["44","782"],["45","893"],["46","852"],["47","826"],["48","707"],["49","733"],["50","699"],["51","710"],["52","699"],["53","657"],["54","579"],["55","589"],["56","564"],["57","642"],["58","584"],["59","583"],["60","465"],["61","123"],["62","74"],["63","68"],["64","65"],["65","50"],["66","53"],["67","43"],["68","26"],["69","34"],["70","53"],["71","42"],["72","44"],["73","36"],["74","32"],["75","27"],["76","24"],["77","38"],["78","18"],["79","17"],["80","29"],["81","9"],["82","10"],["83","12"],["84","6"],["85","4"],["86","6"],["87","3"],["88","2"],["89","2"],["92","2"],["93","2"],["95","1"],["20","3"],["21","5"],["22","9"],["23","27"],["24","53"],["25","98"],["26","170"],["27","233"],["28","325"],["29","463"],["30","675"]]},"dateCreated":"2016-06-28T10:38:31+0000","dateStarted":"2016-06-28T11:18:10+0000","dateFinished":"2016-06-28T11:18:13+0000","status":"FINISHED","progressUpdateIntervalMs":500,"$$hashKey":"object:202","focus":true},{"text":"bank.show()","dateUpdated":"2016-06-28T11:13:54+0000","config":{"colWidth":4,"graph":{"mode":"table","height":300,"optionOpen":false,"keys":[],"values":[],"groups":[],"scatter":{}},"enabled":true,"editorMode":"ace/mode/scala"},"settings":{"params":{},"forms":{}},"jobName":"paragraph_1467110337184_-569792078","id":"20160628-103857_31842461","result":{"code":"SUCCESS","type":"TEXT","msg":"+---+------------+--------+---------+-------+\n|age|         job| marital|education|balance|\n+---+------------+--------+---------+-------+\n| 58|  management| married| tertiary|   2143|\n| 44|  technician|  single|secondary|     29|\n| 33|entrepreneur| married|secondary|      2|\n| 47| blue-collar| married|  unknown|   1506|\n| 33|     unknown|  single|  unknown|      1|\n| 35|  management| married| tertiary|    231|\n| 28|  management|  single| tertiary|    447|\n| 42|entrepreneur|divorced| tertiary|      2|\n| 58|     retired| married|  primary|    121|\n| 43|  technician|  single|secondary|    593|\n| 41|      admin.|divorced|secondary|    270|\n| 29|      admin.|  single|secondary|    390|\n| 53|  technician| married|secondary|      6|\n| 58|  technician| married|  unknown|     71|\n| 57|    services| married|secondary|    162|\n| 51|     retired| married|  primary|    229|\n| 45|      admin.|  single|  unknown|     13|\n| 57| blue-collar| married|  primary|     52|\n| 60|     retired| married|  primary|     60|\n| 33|    services| married|secondary|      0|\n+---+------------+--------+---------+-------+\nonly showing top 20 rows\n\n"},"dateCreated":"2016-06-28T10:38:57+0000","dateStarted":"2016-06-28T11:14:04+0000","dateFinished":"2016-06-28T11:14:06+0000","status":"FINISHED","progressUpdateIntervalMs":500,"$$hashKey":"object:203"},{"text":"%sql select age, count(1) from bank where age < 30 group by age order by age","dateUpdated":"2016-06-28T11:13:54+0000","config":{"colWidth":4,"graph":{"mode":"multiBarChart","height":300,"optionOpen":false,"keys":[{"name":"age","index":0,"aggr":"sum"}],"values":[{"name":"_c1","index":1,"aggr":"sum"}],"groups":[],"scatter":{"xAxis":{"name":"age","index":0,"aggr":"sum"},"yAxis":{"name":"_c1","index":1,"aggr":"sum"}}},"enabled":true,"editorMode":"ace/mode/sql"},"settings":{"params":{},"forms":{}},"jobName":"paragraph_1467111608926_-1361810583","id":"20160628-110008_1189069176","result":{"code":"SUCCESS","type":"TABLE","msg":"age\t_c1\n18\t12\n19\t35\n20\t50\n21\t79\n22\t129\n23\t202\n24\t302\n25\t527\n26\t805\n27\t909\n28\t1038\n29\t1185\n","comment":"","msgTable":[[{"key":"_c1","value":"18"},{"key":"_c1","value":"12"}],[{"value":"19"},{"value":"35"}],[{"value":"20"},{"value":"50"}],[{"value":"21"},{"value":"79"}],[{"value":"22"},{"value":"129"}],[{"value":"23"},{"value":"202"}],[{"value":"24"},{"value":"302"}],[{"value":"25"},{"value":"527"}],[{"value":"26"},{"value":"805"}],[{"value":"27"},{"value":"909"}],[{"value":"28"},{"value":"1038"}],[{"value":"29"},{"value":"1185"}]],"columnNames":[{"name":"age","index":0,"aggr":"sum"},{"name":"_c1","index":1,"aggr":"sum"}],"rows":[["18","12"],["19","35"],["20","50"],["21","79"],["22","129"],["23","202"],["24","302"],["25","527"],["26","805"],["27","909"],["28","1038"],["29","1185"]]},"dateCreated":"2016-06-28T11:00:08+0000","dateStarted":"2016-06-28T11:14:06+0000","dateFinished":"2016-06-28T11:14:08+0000","status":"FINISHED","progressUpdateIntervalMs":500,"$$hashKey":"object:204"},{"text":"%sql select count(*) from bank where marital = 'married' and education = 'primary' and balance > 1000","dateUpdated":"2016-06-28T11:13:54+0000","config":{"colWidth":4,"graph":{"mode":"table","height":300,"optionOpen":false,"keys":[{"name":"_c0","index":0,"aggr":"sum"}],"values":[],"groups":[],"scatter":{"xAxis":{"name":"_c0","index":0,"aggr":"sum"}}},"enabled":true,"editorMode":"ace/mode/sql"},"settings":{"params":{},"forms":{}},"jobName":"paragraph_1467111692289_1376386042","id":"20160628-110132_1743963785","result":{"code":"SUCCESS","type":"TABLE","msg":"_c0\n1664\n","comment":"","msgTable":[[{"value":"1664"}]],"columnNames":[{"name":"_c0","index":0,"aggr":"sum"}],"rows":[["1664"]]},"dateCreated":"2016-06-28T11:01:32+0000","dateStarted":"2016-06-28T11:14:07+0000","dateFinished":"2016-06-28T11:14:09+0000","status":"FINISHED","progressUpdateIntervalMs":500,"$$hashKey":"object:205"},{"text":"bank.printSchema()","dateUpdated":"2016-06-28T11:13:54+0000","config":{"colWidth":6,"graph":{"mode":"table","height":300,"optionOpen":false,"keys":[],"values":[],"groups":[],"scatter":{}},"enabled":true,"editorMode":"ace/mode/scala"},"settings":{"params":{},"forms":{}},"jobName":"paragraph_1467111716675_-1759135248","id":"20160628-110156_1977857692","result":{"code":"SUCCESS","type":"TEXT","msg":"root\n |-- age: integer (nullable = true)\n |-- job: string (nullable = true)\n |-- marital: string (nullable = true)\n |-- education: string (nullable = true)\n |-- balance: integer (nullable = true)\n\n"},"dateCreated":"2016-06-28T11:01:56+0000","dateStarted":"2016-06-28T11:14:09+0000","dateFinished":"2016-06-28T11:14:10+0000","status":"FINISHED","progressUpdateIntervalMs":500,"$$hashKey":"object:206"},{"text":"%sql select * from bank where marital = 'married' and education = 'primary' and balance > 1000 and job rlike '^e.*$'","dateUpdated":"2016-06-28T11:13:54+0000","config":{"colWidth":12,"graph":{"mode":"table","height":300,"optionOpen":false,"keys":[{"name":"age","index":0,"aggr":"sum"}],"values":[{"name":"job","index":1,"aggr":"sum"}],"groups":[],"scatter":{"xAxis":{"name":"age","index":0,"aggr":"sum"},"yAxis":{"name":"job","index":1,"aggr":"sum"}}},"enabled":true,"editorMode":"ace/mode/sql"},"settings":{"params":{},"forms":{}},"jobName":"paragraph_1467111786569_-1470265445","id":"20160628-110306_985705305","result":{"code":"SUCCESS","type":"TABLE","msg":"age\tjob\tmarital\teducation\tbalance\n45\tentrepreneur\tmarried\tprimary\t2418\n45\tentrepreneur\tmarried\tprimary\t1953\n40\tentrepreneur\tmarried\tprimary\t3676\n48\tentrepreneur\tmarried\tprimary\t3705\n54\tentrepreneur\tmarried\tprimary\t3343\n52\tentrepreneur\tmarried\tprimary\t8298\n49\tentrepreneur\tmarried\tprimary\t3112\n46\tentrepreneur\tmarried\tprimary\t1757\n49\tentrepreneur\tmarried\tprimary\t5380\n40\tentrepreneur\tmarried\tprimary\t4674\n58\tentrepreneur\tmarried\tprimary\t1657\n58\tentrepreneur\tmarried\tprimary\t52499\n57\tentrepreneur\tmarried\tprimary\t1153\n36\tentrepreneur\tmarried\tprimary\t6317\n52\tentrepreneur\tmarried\tprimary\t2138\n51\tentrepreneur\tmarried\tprimary\t4711\n44\tentrepreneur\tmarried\tprimary\t5038\n35\tentrepreneur\tmarried\tprimary\t2643\n36\tentrepreneur\tmarried\tprimary\t3352\n41\tentrepreneur\tmarried\tprimary\t1331\n30\tentrepreneur\tmarried\tprimary\t2686\n34\tentrepreneur\tmarried\tprimary\t1188\n50\tentrepreneur\tmarried\tprimary\t1327\n46\tentrepreneur\tmarried\tprimary\t8873\n39\tentrepreneur\tmarried\tprimary\t13930\n49\tentrepreneur\tmarried\tprimary\t10772\n49\tentrepreneur\tmarried\tprimary\t6188\n39\tentrepreneur\tmarried\tprimary\t3373\n46\tentrepreneur\tmarried\tprimary\t8873\n53\tentrepreneur\tmarried\tprimary\t1034\n33\tentrepreneur\tmarried\tprimary\t2339\n48\tentrepreneur\tmarried\tprimary\t2675\n52\tentrepreneur\tmarried\tprimary\t2594\n35\tentrepreneur\tmarried\tprimary\t29397\n58\tentrepreneur\tmarried\tprimary\t1249\n51\tentrepreneur\tmarried\tprimary\t1443\n37\tentrepreneur\tmarried\tprimary\t1529\n38\tentrepreneur\tmarried\tprimary\t1390\n44\tentrepreneur\tmarried\tprimary\t5039\n43\tentrepreneur\tmarried\tprimary\t1318\n46\tentrepreneur\tmarried\tprimary\t5130\n34\tentrepreneur\tmarried\tprimary\t7279\n58\tentrepreneur\tmarried\tprimary\t1153\n43\tentrepreneur\tmarried\tprimary\t2315\n45\tentrepreneur\tmarried\tprimary\t5315\n44\tentrepreneur\tmarried\tprimary\t1434\n51\tentrepreneur\tmarried\tprimary\t1443\n52\tentrepreneur\tmarried\tprimary\t1998\n32\tentrepreneur\tmarried\tprimary\t3083\n63\tentrepreneur\tmarried\tprimary\t2287\n60\tentrepreneur\tmarried\tprimary\t2408\n","comment":"","msgTable":[[{"key":"job","value":"45"},{"key":"job","value":"entrepreneur"},{"key":"job","value":"married"},{"key":"job","value":"primary"},{"key":"job","value":"2418"}],[{"key":"marital","value":"45"},{"key":"marital","value":"entrepreneur"},{"key":"marital","value":"married"},{"key":"marital","value":"primary"},{"key":"marital","value":"1953"}],[{"key":"education","value":"40"},{"key":"education","value":"entrepreneur"},{"key":"education","value":"married"},{"key":"education","value":"primary"},{"key":"education","value":"3676"}],[{"key":"balance","value":"48"},{"key":"balance","value":"entrepreneur"},{"key":"balance","value":"married"},{"key":"balance","value":"primary"},{"key":"balance","value":"3705"}],[{"value":"54"},{"value":"entrepreneur"},{"value":"married"},{"value":"primary"},{"value":"3343"}],[{"value":"52"},{"value":"entrepreneur"},{"value":"married"},{"value":"primary"},{"value":"8298"}],[{"value":"49"},{"value":"entrepreneur"},{"value":"married"},{"value":"primary"},{"value":"3112"}],[{"value":"46"},{"value":"entrepreneur"},{"value":"married"},{"value":"primary"},{"value":"1757"}],[{"value":"49"},{"value":"entrepreneur"},{"value":"married"},{"value":"primary"},{"value":"5380"}],[{"value":"40"},{"value":"entrepreneur"},{"value":"married"},{"value":"primary"},{"value":"4674"}],[{"value":"58"},{"value":"entrepreneur"},{"value":"married"},{"value":"primary"},{"value":"1657"}],[{"value":"58"},{"value":"entrepreneur"},{"value":"married"},{"value":"primary"},{"value":"52499"}],[{"value":"57"},{"value":"entrepreneur"},{"value":"married"},{"value":"primary"},{"value":"1153"}],[{"value":"36"},{"value":"entrepreneur"},{"value":"married"},{"value":"primary"},{"value":"6317"}],[{"value":"52"},{"value":"entrepreneur"},{"value":"married"},{"value":"primary"},{"value":"2138"}],[{"value":"51"},{"value":"entrepreneur"},{"value":"married"},{"value":"primary"},{"value":"4711"}],[{"value":"44"},{"value":"entrepreneur"},{"value":"married"},{"value":"primary"},{"value":"5038"}],[{"value":"35"},{"value":"entrepreneur"},{"value":"married"},{"value":"primary"},{"value":"2643"}],[{"value":"36"},{"value":"entrepreneur"},{"value":"married"},{"value":"primary"},{"value":"3352"}],[{"value":"41"},{"value":"entrepreneur"},{"value":"married"},{"value":"primary"},{"value":"1331"}],[{"value":"30"},{"value":"entrepreneur"},{"value":"married"},{"value":"primary"},{"value":"2686"}],[{"value":"34"},{"value":"entrepreneur"},{"value":"married"},{"value":"primary"},{"value":"1188"}],[{"value":"50"},{"value":"entrepreneur"},{"value":"married"},{"value":"primary"},{"value":"1327"}],[{"value":"46"},{"value":"entrepreneur"},{"value":"married"},{"value":"primary"},{"value":"8873"}],[{"value":"39"},{"value":"entrepreneur"},{"value":"married"},{"value":"primary"},{"value":"13930"}],[{"value":"49"},{"value":"entrepreneur"},{"value":"married"},{"value":"primary"},{"value":"10772"}],[{"value":"49"},{"value":"entrepreneur"},{"value":"married"},{"value":"primary"},{"value":"6188"}],[{"value":"39"},{"value":"entrepreneur"},{"value":"married"},{"value":"primary"},{"value":"3373"}],[{"value":"46"},{"value":"entrepreneur"},{"value":"married"},{"value":"primary"},{"value":"8873"}],[{"value":"53"},{"value":"entrepreneur"},{"value":"married"},{"value":"primary"},{"value":"1034"}],[{"value":"33"},{"value":"entrepreneur"},{"value":"married"},{"value":"primary"},{"value":"2339"}],[{"value":"48"},{"value":"entrepreneur"},{"value":"married"},{"value":"primary"},{"value":"2675"}],[{"value":"52"},{"value":"entrepreneur"},{"value":"married"},{"value":"primary"},{"value":"2594"}],[{"value":"35"},{"value":"entrepreneur"},{"value":"married"},{"value":"primary"},{"value":"29397"}],[{"value":"58"},{"value":"entrepreneur"},{"value":"married"},{"value":"primary"},{"value":"1249"}],[{"value":"51"},{"value":"entrepreneur"},{"value":"married"},{"value":"primary"},{"value":"1443"}],[{"value":"37"},{"value":"entrepreneur"},{"value":"married"},{"value":"primary"},{"value":"1529"}],[{"value":"38"},{"value":"entrepreneur"},{"value":"married"},{"value":"primary"},{"value":"1390"}],[{"value":"44"},{"value":"entrepreneur"},{"value":"married"},{"value":"primary"},{"value":"5039"}],[{"value":"43"},{"value":"entrepreneur"},{"value":"married"},{"value":"primary"},{"value":"1318"}],[{"value":"46"},{"value":"entrepreneur"},{"value":"married"},{"value":"primary"},{"value":"5130"}],[{"value":"34"},{"value":"entrepreneur"},{"value":"married"},{"value":"primary"},{"value":"7279"}],[{"value":"58"},{"value":"entrepreneur"},{"value":"married"},{"value":"primary"},{"value":"1153"}],[{"value":"43"},{"value":"entrepreneur"},{"value":"married"},{"value":"primary"},{"value":"2315"}],[{"value":"45"},{"value":"entrepreneur"},{"value":"married"},{"value":"primary"},{"value":"5315"}],[{"value":"44"},{"value":"entrepreneur"},{"value":"married"},{"value":"primary"},{"value":"1434"}],[{"value":"51"},{"value":"entrepreneur"},{"value":"married"},{"value":"primary"},{"value":"1443"}],[{"value":"52"},{"value":"entrepreneur"},{"value":"married"},{"value":"primary"},{"value":"1998"}],[{"value":"32"},{"value":"entrepreneur"},{"value":"married"},{"value":"primary"},{"value":"3083"}],[{"value":"63"},{"value":"entrepreneur"},{"value":"married"},{"value":"primary"},{"value":"2287"}],[{"value":"60"},{"value":"entrepreneur"},{"value":"married"},{"value":"primary"},{"value":"2408"}]],"columnNames":[{"name":"age","index":0,"aggr":"sum"},{"name":"job","index":1,"aggr":"sum"},{"name":"marital","index":2,"aggr":"sum"},{"name":"education","index":3,"aggr":"sum"},{"name":"balance","index":4,"aggr":"sum"}],"rows":[["45","entrepreneur","married","primary","2418"],["45","entrepreneur","married","primary","1953"],["40","entrepreneur","married","primary","3676"],["48","entrepreneur","married","primary","3705"],["54","entrepreneur","married","primary","3343"],["52","entrepreneur","married","primary","8298"],["49","entrepreneur","married","primary","3112"],["46","entrepreneur","married","primary","1757"],["49","entrepreneur","married","primary","5380"],["40","entrepreneur","married","primary","4674"],["58","entrepreneur","married","primary","1657"],["58","entrepreneur","married","primary","52499"],["57","entrepreneur","married","primary","1153"],["36","entrepreneur","married","primary","6317"],["52","entrepreneur","married","primary","2138"],["51","entrepreneur","married","primary","4711"],["44","entrepreneur","married","primary","5038"],["35","entrepreneur","married","primary","2643"],["36","entrepreneur","married","primary","3352"],["41","entrepreneur","married","primary","1331"],["30","entrepreneur","married","primary","2686"],["34","entrepreneur","married","primary","1188"],["50","entrepreneur","married","primary","1327"],["46","entrepreneur","married","primary","8873"],["39","entrepreneur","married","primary","13930"],["49","entrepreneur","married","primary","10772"],["49","entrepreneur","married","primary","6188"],["39","entrepreneur","married","primary","3373"],["46","entrepreneur","married","primary","8873"],["53","entrepreneur","married","primary","1034"],["33","entrepreneur","married","primary","2339"],["48","entrepreneur","married","primary","2675"],["52","entrepreneur","married","primary","2594"],["35","entrepreneur","married","primary","29397"],["58","entrepreneur","married","primary","1249"],["51","entrepreneur","married","primary","1443"],["37","entrepreneur","married","primary","1529"],["38","entrepreneur","married","primary","1390"],["44","entrepreneur","married","primary","5039"],["43","entrepreneur","married","primary","1318"],["46","entrepreneur","married","primary","5130"],["34","entrepreneur","married","primary","7279"],["58","entrepreneur","married","primary","1153"],["43","entrepreneur","married","primary","2315"],["45","entrepreneur","married","primary","5315"],["44","entrepreneur","married","primary","1434"],["51","entrepreneur","married","primary","1443"],["52","entrepreneur","married","primary","1998"],["32","entrepreneur","married","primary","3083"],["63","entrepreneur","married","primary","2287"],["60","entrepreneur","married","primary","2408"]]},"dateCreated":"2016-06-28T11:03:06+0000","dateStarted":"2016-06-28T11:14:10+0000","dateFinished":"2016-06-28T11:14:11+0000","status":"FINISHED","progressUpdateIntervalMs":500,"$$hashKey":"object:207"},{"dateUpdated":"2016-06-28T11:13:55+0000","config":{"colWidth":12,"graph":{"mode":"table","height":300,"optionOpen":false,"keys":[],"values":[],"groups":[],"scatter":{}},"enabled":true,"editorMode":"ace/mode/scala"},"settings":{"params":{},"forms":{}},"jobName":"paragraph_1467111809417_1343449234","id":"20160628-110329_661411992","result":{"code":"SUCCESS","type":"TEXT","msg":""},"dateCreated":"2016-06-28T11:03:29+0000","dateStarted":"2016-06-28T11:14:10+0000","dateFinished":"2016-06-28T11:14:11+0000","status":"FINISHED","progressUpdateIntervalMs":500,"$$hashKey":"object:208"}],"name":"Banks","id":"2BRBCHQ7B","angularObjects":{"2BRNN1YWF:shared_process":[],"2BQQHMZDM:shared_process":[],"2BS59CANV:shared_process":[],"2BR56KEMS:shared_process":[],"2BPAA2PKF:shared_process":[],"2BQVWB6ZS:shared_process":[],"2BR1GFZQF:shared_process":[],"2BPT7RW3J:shared_process":[]},"config":{"looknfeel":"default"},"info":{}}