You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@kylin.apache.org by 周湘伦 <ja...@gmail.com> on 2017/09/04 10:30:51 UTC
Re: when status of segment is 'NEW',the last_build_job_id is null
Thank you for your answer.
One more question:
how can i search for the failed job list? By command or API?
2017-08-31 8:55 GMT+08:00 ShaoFeng Shi <sh...@apache.org>:
> Hi,
>
> If resume a job, you need get the job uuid; The uuid was returned when you
> submit the job request.
>
> Another way is to do a search for the failed job list, and get the job uuid
> from the result.
>
> The segment's "last_build_job_id" will be updated when there is a
> successful build. In your case as there is no success build, so it is null.
>
> If you're using Chrome browser, press F12 or right click "Inspect", in the
> "Network" tab, you will see how Kylin's frontend call Kylin REST server,
> that is the easist way to learn the REST API.
>
>
> 2017-08-30 18:36 GMT+08:00 周湘伦 <ja...@gmail.com>:
>
> > Hi,all
> >
> > When the job execution failed,or pending,then i get cube information:
> > ...
> > {"uuid":"523623e7-6233-4a91-af15-b8f846ae6063","name":"
> > 20170610000000_20170611000000","storage_location_identifier"
> > :"KYLIN_P1MD9NPHP3","date_range_start":1497052800000,"
> > date_range_end":1497139200000,"source_offset_start":0,"
> > source_offset_end":0,"status":"NEW","size_kb":0,"input_
> > records":0,"input_records_size":0,"last_build_time":0,"
> > last_build_job_id":null,"creat
> > e_time_utc":1504077397616,"cuboid_shard_nums":{},"total_
> > shards":1,"blackout_cuboids":[],"binary_signature":null,"
> > dictionaries":{"TBL
> > ...
> >
> > The 'last_build_job_id' is null.
> > I want resume the job with restful API,so which field should I get?
> >
> > Best regards.
> >
> >
>
>
> --
> Best regards,
>
> Shaofeng Shi 史少锋
>
Re: when status of segment is 'NEW',the last_build_job_id is null
Posted by 周湘伦 <ja...@gmail.com>.
Thank you. I didn't has error message.
If building a cube fails or spend too much time, I'll find out which step
is wrong，then discard or resume job with api.This is what i want to do.
But i don't know how to use this api http://kylin.apache.org/
docs21/howto/howto_use_restapi.html#get-job-list with curl or code with
libcurl.
I know how to use this api (GET
/kylin/api/jobs/{jobId}/steps/{stepId}/output), because i know how to fill
these parameters. But this api(GET /kylin/api/jobs) ,i don't know how to
use fill these parameters (cubeName ,projectNam,status, offset, limit,
timeFilter ), can you give me an example of using this api with curl?
2017-10-08 8:47 GMT+08:00 Li Yang <li...@apache.org>:
> Please describe detailed error message, or others cannot help.
>
> On Mon, Sep 25, 2017 at 8:34 PM, 周湘伦 <ja...@gmail.com> wrote:
>
> > Thank you for your answer.
> > But i don't kwon how to use curl to get job list,like this?
> > curl -X GET -H "Authorization: Basic QURNSU46S1lMSU4=" -H
> > "Content-Type:application/json"
> > http://198.19.1.49:7070/kylin/api/jobs?CubeName=Indus_Trans_
> > Cube&projectName=yxlm_cs&status=1&offset=1&limit=10&timeFilter=1
> >
> > it didn't work 😢.
> > Can you help me?
> >
> > 2017-09-10 16:09 GMT+08:00 Li Yang <li...@apache.org>:
> >
> > > Both the GUI (jobs panel) and Rest API can find failed jobs.
> > > http://kylin.apache.org/docs21/howto/howto_use_
> restapi.html#get-job-list
> > >
> > > On Mon, Sep 4, 2017 at 6:30 PM, 周湘伦 <ja...@gmail.com> wrote:
> > >
> > > > Thank you for your answer.
> > > > One more question:
> > > > how can i search for the failed job list? By command or API?
> > > >
> > > >
> > > > 2017-08-31 8:55 GMT+08:00 ShaoFeng Shi <sh...@apache.org>:
> > > >
> > > > > Hi,
> > > > >
> > > > > If resume a job, you need get the job uuid; The uuid was returned
> > when
> > > > you
> > > > > submit the job request.
> > > > >
> > > > > Another way is to do a search for the failed job list, and get the
> > job
> > > > uuid
> > > > > from the result.
> > > > >
> > > > > The segment's "last_build_job_id" will be updated when there is a
> > > > > successful build. In your case as there is no success build, so it
> is
> > > > null.
> > > > >
> > > > > If you're using Chrome browser, press F12 or right click "Inspect",
> > in
> > > > the
> > > > > "Network" tab, you will see how Kylin's frontend call Kylin REST
> > > server,
> > > > > that is the easist way to learn the REST API.
> > > > >
> > > > >
> > > > > 2017-08-30 18:36 GMT+08:00 周湘伦 <ja...@gmail.com>:
> > > > >
> > > > > > Hi,all
> > > > > >
> > > > > > When the job execution failed,or pending,then i get cube
> > > information:
> > > > > > ...
> > > > > > {"uuid":"523623e7-6233-4a91-af15-b8f846ae6063","name":"
> > > > > > 20170610000000_20170611000000","storage_location_identifier"
> > > > > > :"KYLIN_P1MD9NPHP3","date_range_start":1497052800000,"
> > > > > > date_range_end":1497139200000,"source_offset_start":0,"
> > > > > > source_offset_end":0,"status":"NEW","size_kb":0,"input_
> > > > > > records":0,"input_records_size":0,"last_build_time":0,"
> > > > > > last_build_job_id":null,"creat
> > > > > > e_time_utc":1504077397616,"cuboid_shard_nums":{},"total_
> > > > > > shards":1,"blackout_cuboids":[],"binary_signature":null,"
> > > > > > dictionaries":{"TBL
> > > > > > ...
> > > > > >
> > > > > > The 'last_build_job_id' is null.
> > > > > > I want resume the job with restful API,so which field should I
> > get?
> > > > > >
> > > > > > Best regards.
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > > --
> > > > > Best regards,
> > > > >
> > > > > Shaofeng Shi 史少锋
> > > > >
> > > >
> > >
> >
>
Re: when status of segment is 'NEW',the last_build_job_id is null
Posted by Li Yang <li...@apache.org>.
Please describe detailed error message, or others cannot help.
On Mon, Sep 25, 2017 at 8:34 PM, 周湘伦 <ja...@gmail.com> wrote:
> Thank you for your answer.
> But i don't kwon how to use curl to get job list,like this?
> curl -X GET -H "Authorization: Basic QURNSU46S1lMSU4=" -H
> "Content-Type:application/json"
> http://198.19.1.49:7070/kylin/api/jobs?CubeName=Indus_Trans_
> Cube&projectName=yxlm_cs&status=1&offset=1&limit=10&timeFilter=1
>
> it didn't work 😢.
> Can you help me?
>
> 2017-09-10 16:09 GMT+08:00 Li Yang <li...@apache.org>:
>
> > Both the GUI (jobs panel) and Rest API can find failed jobs.
> > http://kylin.apache.org/docs21/howto/howto_use_restapi.html#get-job-list
> >
> > On Mon, Sep 4, 2017 at 6:30 PM, 周湘伦 <ja...@gmail.com> wrote:
> >
> > > Thank you for your answer.
> > > One more question:
> > > how can i search for the failed job list? By command or API?
> > >
> > >
> > > 2017-08-31 8:55 GMT+08:00 ShaoFeng Shi <sh...@apache.org>:
> > >
> > > > Hi,
> > > >
> > > > If resume a job, you need get the job uuid; The uuid was returned
> when
> > > you
> > > > submit the job request.
> > > >
> > > > Another way is to do a search for the failed job list, and get the
> job
> > > uuid
> > > > from the result.
> > > >
> > > > The segment's "last_build_job_id" will be updated when there is a
> > > > successful build. In your case as there is no success build, so it is
> > > null.
> > > >
> > > > If you're using Chrome browser, press F12 or right click "Inspect",
> in
> > > the
> > > > "Network" tab, you will see how Kylin's frontend call Kylin REST
> > server,
> > > > that is the easist way to learn the REST API.
> > > >
> > > >
> > > > 2017-08-30 18:36 GMT+08:00 周湘伦 <ja...@gmail.com>:
> > > >
> > > > > Hi,all
> > > > >
> > > > > When the job execution failed,or pending,then i get cube
> > information:
> > > > > ...
> > > > > {"uuid":"523623e7-6233-4a91-af15-b8f846ae6063","name":"
> > > > > 20170610000000_20170611000000","storage_location_identifier"
> > > > > :"KYLIN_P1MD9NPHP3","date_range_start":1497052800000,"
> > > > > date_range_end":1497139200000,"source_offset_start":0,"
> > > > > source_offset_end":0,"status":"NEW","size_kb":0,"input_
> > > > > records":0,"input_records_size":0,"last_build_time":0,"
> > > > > last_build_job_id":null,"creat
> > > > > e_time_utc":1504077397616,"cuboid_shard_nums":{},"total_
> > > > > shards":1,"blackout_cuboids":[],"binary_signature":null,"
> > > > > dictionaries":{"TBL
> > > > > ...
> > > > >
> > > > > The 'last_build_job_id' is null.
> > > > > I want resume the job with restful API,so which field should I
> get?
> > > > >
> > > > > Best regards.
> > > > >
> > > > >
> > > >
> > > >
> > > > --
> > > > Best regards,
> > > >
> > > > Shaofeng Shi 史少锋
> > > >
> > >
> >
>
Re: when status of segment is 'NEW',the last_build_job_id is null
Posted by 周湘伦 <ja...@gmail.com>.
Thank you for your answer.
But i don't kwon how to use curl to get job list,like this?
curl -X GET -H "Authorization: Basic QURNSU46S1lMSU4=" -H
"Content-Type:application/json"
http://198.19.1.49:7070/kylin/api/jobs?CubeName=Indus_Trans_Cube&projectName=yxlm_cs&status=1&offset=1&limit=10&timeFilter=1
it didn't work 😢.
Can you help me?
2017-09-10 16:09 GMT+08:00 Li Yang <li...@apache.org>:
> Both the GUI (jobs panel) and Rest API can find failed jobs.
> http://kylin.apache.org/docs21/howto/howto_use_restapi.html#get-job-list
>
> On Mon, Sep 4, 2017 at 6:30 PM, 周湘伦 <ja...@gmail.com> wrote:
>
> > Thank you for your answer.
> > One more question:
> > how can i search for the failed job list? By command or API?
> >
> >
> > 2017-08-31 8:55 GMT+08:00 ShaoFeng Shi <sh...@apache.org>:
> >
> > > Hi,
> > >
> > > If resume a job, you need get the job uuid; The uuid was returned when
> > you
> > > submit the job request.
> > >
> > > Another way is to do a search for the failed job list, and get the job
> > uuid
> > > from the result.
> > >
> > > The segment's "last_build_job_id" will be updated when there is a
> > > successful build. In your case as there is no success build, so it is
> > null.
> > >
> > > If you're using Chrome browser, press F12 or right click "Inspect", in
> > the
> > > "Network" tab, you will see how Kylin's frontend call Kylin REST
> server,
> > > that is the easist way to learn the REST API.
> > >
> > >
> > > 2017-08-30 18:36 GMT+08:00 周湘伦 <ja...@gmail.com>:
> > >
> > > > Hi,all
> > > >
> > > > When the job execution failed,or pending,then i get cube
> information:
> > > > ...
> > > > {"uuid":"523623e7-6233-4a91-af15-b8f846ae6063","name":"
> > > > 20170610000000_20170611000000","storage_location_identifier"
> > > > :"KYLIN_P1MD9NPHP3","date_range_start":1497052800000,"
> > > > date_range_end":1497139200000,"source_offset_start":0,"
> > > > source_offset_end":0,"status":"NEW","size_kb":0,"input_
> > > > records":0,"input_records_size":0,"last_build_time":0,"
> > > > last_build_job_id":null,"creat
> > > > e_time_utc":1504077397616,"cuboid_shard_nums":{},"total_
> > > > shards":1,"blackout_cuboids":[],"binary_signature":null,"
> > > > dictionaries":{"TBL
> > > > ...
> > > >
> > > > The 'last_build_job_id' is null.
> > > > I want resume the job with restful API,so which field should I get?
> > > >
> > > > Best regards.
> > > >
> > > >
> > >
> > >
> > > --
> > > Best regards,
> > >
> > > Shaofeng Shi 史少锋
> > >
> >
>
Re: when status of segment is 'NEW',the last_build_job_id is null
Posted by Li Yang <li...@apache.org>.
Both the GUI (jobs panel) and Rest API can find failed jobs.
http://kylin.apache.org/docs21/howto/howto_use_restapi.html#get-job-list
On Mon, Sep 4, 2017 at 6:30 PM, 周湘伦 <ja...@gmail.com> wrote:
> Thank you for your answer.
> One more question:
> how can i search for the failed job list? By command or API?
>
>
> 2017-08-31 8:55 GMT+08:00 ShaoFeng Shi <sh...@apache.org>:
>
> > Hi,
> >
> > If resume a job, you need get the job uuid; The uuid was returned when
> you
> > submit the job request.
> >
> > Another way is to do a search for the failed job list, and get the job
> uuid
> > from the result.
> >
> > The segment's "last_build_job_id" will be updated when there is a
> > successful build. In your case as there is no success build, so it is
> null.
> >
> > If you're using Chrome browser, press F12 or right click "Inspect", in
> the
> > "Network" tab, you will see how Kylin's frontend call Kylin REST server,
> > that is the easist way to learn the REST API.
> >
> >
> > 2017-08-30 18:36 GMT+08:00 周湘伦 <ja...@gmail.com>:
> >
> > > Hi,all
> > >
> > > When the job execution failed,or pending,then i get cube information:
> > > ...
> > > {"uuid":"523623e7-6233-4a91-af15-b8f846ae6063","name":"
> > > 20170610000000_20170611000000","storage_location_identifier"
> > > :"KYLIN_P1MD9NPHP3","date_range_start":1497052800000,"
> > > date_range_end":1497139200000,"source_offset_start":0,"
> > > source_offset_end":0,"status":"NEW","size_kb":0,"input_
> > > records":0,"input_records_size":0,"last_build_time":0,"
> > > last_build_job_id":null,"creat
> > > e_time_utc":1504077397616,"cuboid_shard_nums":{},"total_
> > > shards":1,"blackout_cuboids":[],"binary_signature":null,"
> > > dictionaries":{"TBL
> > > ...
> > >
> > > The 'last_build_job_id' is null.
> > > I want resume the job with restful API,so which field should I get?
> > >
> > > Best regards.
> > >
> > >
> >
> >
> > --
> > Best regards,
> >
> > Shaofeng Shi 史少锋
> >
>