• Home
• com.github.rumbledb
• rumble
• 1.1
• source code
• OrderbyClause1.jq

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

test_files.runtime-spark.DataFrames.OrderbyClause1.jq Maven / Gradle / Ivy

(:JIQS: ShouldRun; Output="({ "guess" : "Bulgarian", "target" : "Albanian", "country" : "AU", "choices" : [ "Albanian", "Bulgarian", "Russian", "Ukrainian" ], "sample" : "00b85faa8b878a14f8781be334deb137", "date" : "2013-08-19" }, { "guess" : "Arabic", "target" : "Arabic", "country" : "IN", "choices" : [ "Arabic", "Greek", "Hebrew", "Spanish" ], "sample" : "8903e496bf04c3a85a70e1dc5e0da5f1", "date" : "2013-08-20" }, { "guess" : "Arabic", "target" : "Arabic", "country" : "AU", "choices" : [ "Arabic", "Cantonese", "Maltese", "Samoan" ], "sample" : "83c6ffcb085ce9c18c0e2aff00dda865", "date" : "2013-08-20" }, { "guess" : "Arabic", "target" : "Arabic", "country" : "AU", "choices" : [ "Albanian", "Arabic", "Czech", "Dutch" ], "sample" : "cd438a022d83ce4ded75d4f9c6ea7239", "date" : "2013-08-20" }, { "guess" : "Tagalog", "target" : "Arabic", "country" : "AU", "choices" : [ "Arabic", "Estonian", "Tagalog", "Malayalam" ], "sample" : "154ac3670f21586ab168cd376290bcb7", "date" : "2013-08-20" }, { "guess" : "Arabic", "target" : "Arabic", "country" : "AU", "choices" : [ "Arabic", "Bulgarian", "Latvian", "Urdu" ], "sample" : "8903e496bf04c3a85a70e1dc5e0da5f1", "date" : "2013-08-19" }, { "guess" : "Arabic", "target" : "Arabic", "country" : "AU", "choices" : [ "Arabic", "Croatian", "Malay", "Serbian" ], "sample" : "8903e496bf04c3a85a70e1dc5e0da5f1", "date" : "2013-08-19" }, { "guess" : "Slovenian", "target" : "Norwegian", "country" : "AU", "choices" : [ "Dinka", "Nepali", "Norwegian", "Slovenian" ], "sample" : "208e1606aa365f3ed573adc7111f58e9", "date" : "2013-08-19" })" :)
for $i in parallelize((
 {"guess": "Slovenian", "target": "Norwegian", "country": "AU", "choices": ["Dinka", "Nepali", "Norwegian", "Slovenian"], "sample": "208e1606aa365f3ed573adc7111f58e9", "date": "2013-08-19"},
 {"guess": "Arabic", "target": "Arabic", "country": "AU", "choices": ["Arabic", "Bulgarian", "Latvian", "Urdu"], "sample": "8903e496bf04c3a85a70e1dc5e0da5f1", "date": "2013-08-19"},
 {"guess": "Arabic", "target": "Arabic", "country": "AU", "choices": ["Arabic", "Croatian", "Malay", "Serbian"], "sample": "8903e496bf04c3a85a70e1dc5e0da5f1", "date": "2013-08-19"},
 {"guess": "Arabic", "target": "Arabic", "country": "AU", "choices": ["Arabic", "Cantonese", "Maltese", "Samoan"], "sample": "83c6ffcb085ce9c18c0e2aff00dda865", "date": "2013-08-20"},
 {"guess": "Arabic", "target": "Arabic", "country": "AU", "choices": ["Albanian", "Arabic", "Czech", "Dutch"], "sample": "cd438a022d83ce4ded75d4f9c6ea7239", "date": "2013-08-20"},
 {"guess": "Arabic", "target": "Arabic", "country": "IN", "choices": ["Arabic", "Greek", "Hebrew", "Spanish"], "sample": "8903e496bf04c3a85a70e1dc5e0da5f1", "date": "2013-08-20"},
 {"guess": "Tagalog", "target": "Arabic", "country": "AU", "choices": ["Arabic", "Estonian", "Tagalog", "Malayalam"], "sample": "154ac3670f21586ab168cd376290bcb7", "date": "2013-08-20"},
 {"guess": "Bulgarian", "target": "Albanian", "country": "AU", "choices": ["Albanian", "Bulgarian", "Russian", "Ukrainian"], "sample": "00b85faa8b878a14f8781be334deb137", "date": "2013-08-19"}))
let $guess := $i."guess", $target := $i."target"
order by $target, $i.country descending, $i.date descending
return $i

(: test with no null or empty entires:)