Another workaround is to trigger PUT kylin/api/cubes/AnalyticsCube/holes to fill up the holes.
2017-10-10 18:01 GMT+08:00 Billy Liu <[email protected]>: > The code is a little old. Could you have a try on the latest 2.1? > > 2017-10-09 15:41 GMT+08:00 <[email protected]>: > >> Thank you for your reply Billy. I tried with 'force'=true parameter but >> its giving same exception as, >> >> >> >> I used as below, >> >> >> >> /usr/bin/curl -b /home/hdfs/cookiefile.txt --user ADMIN:KYLIN -X PUT -H >> 'Content-Type: application/json' -d '{"startTime":'1498867200000', >> "endTime":'1507366853000',"buildType":"MERGE","force":true}' >> http://192.168.1.135:7070/kylin/api/cubes/trinityAnalyticsCube/rebuild >> >> >> >> *EXCEPTION:* >> >> >> >> {"url":"http://ipaddress:7070/kylin/api/cubes/AnalyticsCube/rebuild","exception":"Merging >> segments must not have holes between >> AnalyticsCube[20170701000000_20170911192537] >> and AnalyticsCube[20170912102545_20170912131004]"} >> >> >> >> >> >> >> >> *From:* Billy Liu [mailto:[email protected]] >> *Sent:* Sunday, October 08, 2017 1:52 PM >> >> *To:* user >> *Subject:* Re: How to merge cube segments with holes? >> >> >> >> Sorry, my fault. Just check the code again, the parameter should be >> "force", not "isForce". >> >> >> >> 2017-10-04 12:58 GMT+08:00 <[email protected]>: >> >> HI, >> >> I am using Kylin 1.6 and i tried with isForce=true parameter but its >> giving as com.fasterxml.jackson.databind.exc.UnrecognizedPropertyException: >> Unrecognized field \"isForce\" >> >> >> >> /usr/bin/curl -b /home/hdfs/cookiefile.txt --user ADMIN:KYLIN -X PUT -H >> 'Content-Type: application/json' -d '{"startTime":'1498867200000', >> "endTime":'1507112233000',"buildType":"MERGE","isForce":true}' >> http://192.168.1.135:7070/kylin/api/cubes/trinityAnalyticsCube/rebuild >> >> >> >> >> >> {"url":"http://192.168.1.135:7070/kylin/api/cubes/AnalyticsCube/rebuild >> ","exception":"Could not read JSON: Unrecognized field \"isForce\" >> (class org.apache.kylin.rest.request.JobBuildRequest), not marked as >> ignorable (5 known properties: \"endTime\", \"force\", \"startTime\", >> \"buildType\", \"forceMergeEmptySegment\"])\n at [Source: >> org.apache.catalina.connector.CoyoteInputStream@61b3d534; line: 1, >> column: 87] (through reference chain: >> org.apache.kylin.rest.request.JobBuildRequest[\"isForce\"]); >> nested exception is com.fasterxml.jackson.databind >> .exc.UnrecognizedPropertyException: Unrecognized field \"isForce\" >> (class org.apache.kylin.rest.request.JobBuildRequest), not marked as >> ignorable (5 known properties: \"endTime\", \"force\", \"startTime\", >> \"buildType\", \"forceMergeEmptySegment\"])\n at [Source: >> org.apache.catalina.connector.CoyoteInputStream@61b3d534; line: 1, >> column: 87] (through reference chain: org.apache.kylin.rest.request. >> JobBuildRequest[\"isForce\"])"} >> >> >> >> >> >> I tried with force=true parameter also, its giving as, >> >> >> >> {"url":"http://192.168.1.135:7070/kylin/api/cubes/trinityAna >> lyticsCube/rebuild","exception":"Merging segments must not have holes >> between trinityAnalyticsCube[20170701000000_20170911192537] and >> trinityAnalyticsCube[20170912102545_20170912131004]"} >> >> >> >> Please suggest me which one I have to use? >> >> >> >> *From:* Billy Liu [mailto:[email protected]] >> *Sent:* Wednesday, October 04, 2017 4:44 AM >> *To:* user >> *Subject:* Re: How to merge cube segments with holes? >> >> >> >> First, the isForceMergeEmptySegment has been deprecated, use >> isForce instead is OK in your case. >> >> Second, the stacktrace shows the error is from the parameter >> serialization issue, not from the backend code. The error line1 column 15 >> may indicate the wrong parser in $marge_start_time. Could you replace this >> variable into the number and try again? >> >> >> >> 2017-10-03 22:34 GMT+08:30 <[email protected]>: >> >> I am using forceMergeEmptySegment parameter for merging empty segments, >> can please tell me the parameter for holes between segments.I tried what >> you suggested previous, but its giving wrong parameter as error. I am using >> the below for merging, >> >> >> >> /usr/bin/curl -b /home/hdfs/cookiefile.txt --user ADMIN:KYLIN -X PUT -H >> 'Content-Type: application/json' -d '{"startTime":'$marge_start_time', >> "endTime":'$merger_end_time',"buildType":"MERGE","forceMerge >> EmptySegment":true,"isForce":true}' http://192.168.1.61:7070/kylin >> /api/cubes/EnvironmentDetailsCube/rebuild. >> >> >> >> error as follows, >> >> >> >> {"url":"http://10.82.0.17:7070/kylin/api/cubes/CameraAlertCube/rebuild","exception":"Could >> not read JSON: Unexpected character (',' (code 44)): expected a valid value >> (number, String, array, object, 'true', 'false' or 'null')\n at [Source: >> org.apache.catalina.connector.CoyoteInputStream@10255ad; line: 1, >> column: 15]; nested exception is >> com.fasterxml.jackson.core.JsonParseException: >> Unexpected character (',' (code 44)): expected a valid value (number, >> String, array, object, 'true', 'false' or 'null')\n at [Source: >> org.apache.catalina.connector.CoyoteInputStream@10255ad; line: 1, >> column: 15]"} >> >> >> >> >> >> Please provide me proper way to do this.. >> >> >> >> >> >> *From:* Billy Liu [mailto:[email protected]] >> *Sent:* Tuesday, October 03, 2017 7:15 PM >> *To:* user >> *Subject:* Re: How to merge cube segments with holes? >> >> >> >> The merge API has one parameter named isForce in JobBuildRequest. Could >> you set it to true and try again? >> >> >> >> 2017-10-03 20:25 GMT+08:30 <[email protected]>: >> >> Hi all, >> >> >> >> Anybody have any idea about how to merge cube segments with hole. if I >> tried to merge its giving as, >> >> >> >> >> >> Merging segments must not have holes between >> CameraAlertCube[20170926120000_20170926154956] and >> CameraAlertCube[20170926161959_20170926165002] >> >> >> >> >> >> can you please help me how to solve this problem.... >> >> >> >> >> >> Thanks & Regards, >> >> Prasanna.P >> >> >> >> >> >> >> >> >> > >
