Stack Overflow
Stack Overflow

Questions tagged [jjaql]

A query language designed for JSON.

Jaql is a query language designed for Javascript Object Notation (JSON), a data format that has become popular because of its simplicity and modeling flexibility. Jaql is primarily used to analyze large-scale semi-structured data. Core features include user extensibility and parallelism. In addition to modeling semi-structured data, JSON simplifies extensibility. Hadoop's Map-Reduce is used for parallelism.

https://code.google.com/p/jaql/

13 questions
3
votes
1 answer

Xml parsing with pig Latin

I am very new to both Hadoop and Pig. I have been able to do a number of simple programs but one which is taxing me is processing XML when part of an XML file is malformed. I can use XMLLoader('tag') to get all of the tags from an xml file which is…
user2954068
  • 31
  • 1
2
votes
1 answer

How to programmatically read schema from header file in jaql?

I am trying to achieve the following in JAQL and am stuck. I have two files: File data.tsv, which contains tab separated data, and a file header.tsv, which contains exactly one line with tab separated values, corresponding to the "header" of file…
Blaubaer
  • 654
  • 1
  • 5
  • 15
1
vote
1 answer

How to fetch SHA_256 value from manifest.json file in JFROG

I am trying to fetch the SHA_256 value from manifest.json file but unable to get using aql. Below is the cmd I am using: ubuntu@test:~$ **curl -sS -u sumkumar:$pw -XPOST -k -H "Content-type: text/plain" https:///artifactory/api/search/aql -d…
dell xps
  • 41
  • 5
1
vote
0 answers

how to get output in the below format from the following json data using jaql script

I am doing a facebook analysis project using jaql, from the below json data. i need to get the name of the of the page when i give an id. for example, if i give id: '327945414026898'then i should get name: 'first name'. i have tried the following…
Kotha Praneeth Sai
  • 77
  • 10
1
vote
0 answers

JAQL alternative solution

Is there any alternative solution for JAQL ? I figured out it is not update since 2011. I want JSON query language with join, group and filters and it can be embed with java.
Arun
  • 11
  • 1
1
vote
1 answer

Hadoop conf files missing

i am using hadoop through a Vm Image on RHEL 5 provided by Ibm BigInsights , i am unable to locate the conf folder . I want to embedd jaql with eclipse to develop a front end.
user3500433
  • 11
  • 3
0
votes
1 answer

How to find specific element in JSON without model

I have a JSON data like this … { { "School": "ABC School", "School Address": [ { "Office": "Road No 123" }, { "Admin Office": "Road No 321" }, { "Admission Office": "Road No 456" } ], "School Brach": [ { "Brach name": "North…
Biswajit
  • 323
  • 4
  • 15
0
votes
1 answer

Converting Json into sequential file for hadoop

I have a json file (Size 2-3 GB) stored inside HDFS. My flies look like this format { "DateTime" : 24-08-2015T00:00:00, "Cost":53.09,"UID":9,"Channel":"some Channel"} { "DateTime" : 25-08-2015T00:00:00, "Cost":54.09,"UID":8,"Channel":"some…
sangita
  • 191
  • 5
  • 14
0
votes
1 answer

JAQL append constant string

On JAQL Shell, I have a variable that writes into my HDFS location. The variable use write function and writes to HDFS location. I want to append two more additional constant strings. How do I do that?
user2033072
  • 51
  • 2
0
votes
1 answer

JAQL Cast int to string

I am newbie to jaql, not of lot of documentation is found. Does jaql support inbuilt casting. Or java udf need to be written for casting. I basically want to convert int to string.
Srikanth
  • 15
  • 1
  • 3
0
votes
1 answer

reading json objects in hadoop map reduce for processing data

iam a beginner in hadoop,can any one help me in reading json in mapreduce job. i have googled and found jaql is suitable for reading json.but i didnot find any documentaion on how it could be implemented in our map reduce job. is there any other…
user1585111
  • 1,019
  • 6
  • 19
  • 35
0
votes
0 answers

How to configure Jaql with an existing Hadoop Cluster and use jaql oprators to filter the result?

When I read a file from hdfs by giving it proper path the file is read successfully but when I try to use transform operator of jaql it throws an exception as given below and if I try to execute the code on JAQL shell then an exception is thrown of…
Harmin
  • 11
  • 2
0
votes
1 answer

Jaql - top operator default order

Per IBM documentation at - http://publib.boulder.ibm.com/infocenter/bigins/v1r1/index.jsp?topic=%2Fcom.ibm.swg.im.infosphere.biginsights.doc%2Fdoc%2Fc0057749.html the default order of Jaql's top operator is ascending. But when I run it, I see the…
Sumod
  • 3,806
  • 9
  • 50
  • 69