1 2 3 4 | > cat jsonline.txt {"name": "Tom", "sex": "man", "age": "23", "occupation": "student"} {"name": "Alice", "sex": "femal", "age": "35", "occupation": "teacher"} {"name": "Ben", "sex": "male", "age": "33", "occupation": "police"} |
1 2 3 4 5 6 | jaql> read(lines('file:///xvdc/gaoyunhe/develop/jsonline.txt')); [ "{\"name\": \"Tom\", \"sex\": \"man\", \"age\": \"23\", \"occupation\": \"student\"}", "{\"name\": \"Alice\", \"sex\": \"femal\", \"age\": 35\", \"occupation\": \"teacher\"}", "{\"name\": \"Ben\", \"sex\": \"male\", \"age\": \"33\", \"occupation\": \"police\"}" ] |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 | jaql> read(lines('file:///xvdc/gaoyunhe/develop/jsonline.txt')) -> transform json($); [ { "age": "33", "name": "Ben", "occupation": "police", "sex": "male" }, { "age": "23", "name": "Tom", "occupation": "student", "sex": "man" }, { "age": "35", "name": "Alice", "occupation": "teacher", "sex": "femal" } ] |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 | jaql> read(lines('file:///xvdc/gaoyunhe/develop/jsonline.txt')) -> transform catch( json($), {errThresh: 3} , $) -> filter not(isnull($)); [ { "age": "33", "name": "Ben", "occupation": "police", "sex": "male" }, { "age": "23", "name": "Tom", "occupation": "student", "sex": "man" }, { "age": "35", "name": "Alice", "occupation": "teacher", "sex": "femal" } ] |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 | jaql> read(seq("file:///xvdc/gaoyunhe/develop/jsonline.seq")) -> transform catch( json($), {errThresh: 3} , $) -> filter not(isnull($)); [ { "age": "23", "name": "Tom", "occupation": "student", "sex": "man" }, { "age": "35", "name": "Alice", "occupation": "teacher", "sex": "femal" }, { "age": "33", "name": "Ben", "occupation": "police", "sex": "male" } ] |
欢迎光临 电子技术论坛_中国专业的电子工程师学习交流社区-中电网技术论坛 (http://bbs.eccn.com/) | Powered by Discuz! 7.0.0 |