hadoop - PIG - matching toDate function -

-

i trying cast string datetime object in hadoop pig. grunt give me strange error message : can't choose correct 'todate' function. asking 'explicit cast', have no clue how so. idea ?

=> error 1045: not infer matching function org.apache.pig.builtin.todate multiple or none of them fit. please use explicit cast.

grunt> describe infos_by_nu_affa; infos_by_nu_affa: {nu_affa: bytearray,affaires: {(nu_affa:bytearray,nu_pcp: bytearray,debut: bytearray,fin: bytearray)},prestations: {(nu_affa: bytearray,montant: bytearray,date: bytearray,nu_presta: bytearray,beneficiaire: bytearray)},clients: {(nu_pcp: bytearray,nom: bytearray,prenom: bytearray)}}   derivees = foreach infos_by_nu_affa  generate *, todate(affaires.debut, 'dd/mm/yyyy') (debut:datetime); 2015-03-28 15:46:36,089 [main] error org.apache.pig.tools.grunt.grunt - error 1045: <line 155, column 0> not infer matching function org.apache.pig.builtin.todate multiple or none of them fit. please use explicit cast.   grunt> dump infos_by_nu_affa (affaire5,{(affaire5,client5,01/01/14,05/01/15)},{},{(client5,enders,kililan)}) (affaire6,{(affaire6,client6,01/01/13,01/06/14)},{},{(client6,blanco,martine)}) (affaire7,{(affaire7,client7,01/01/10,02/03/13)},{},{(client7,sarah,moore)}) (affaire8,{(affaire8,client8,01/01/15,01/01/01)},{},{(client8,evrard,dominique)})    grunt> derivees = foreach infos_by_nu_affa  >> generate *, >> count(prestations) nb_prestations, >> todate(affaires.debut, 'dd/mm/yy') debut; 2015-03-28 15:56:06,729 [main] error org.apache.pig.tools.grunt.grunt - error 1045:  <line 155, column 0> not infer matching function org.apache.pig.builtin.todate multiple or none of them fit. please use explicit cast.

the reason passing bag datatype(ie,affaires.debut) input todate function todate function accept chararray or byterarray input. solve issue, need flatten (affaires.debut) before passing todate function. should this

derivees_temp = foreach infos_by_nu_affa  generate *,flatten(affaires.debut) (debut_temp:chararray); derivees = foreach derivees_temp  generate *, todate(debut_temp, 'dd/mm/yyyy') (debut:datetime);

note: in first stmt(ie,derivees_temp), after flattening datatype debut_temp chararray , second stmt(ie, derivees) after todate datatype debut datetime.


Comments

Post a Comment

Popular posts from this blog

angularjs - Showing an empty as first option in select tag -

-
my app showing empty select field first entry. have read other solution given , tried still not working. my controller code is: .controller('usercreatecontroller', function(user,profile,auth) { alert("hello"); var vm = this; vm.type = 'create'; profile.all() //this service fetch profiles shown in select field .success(function(data){ vm.profile = data; }); vm.userdata.profile = vm.profile[0]; //here have set default value select field and html page is: <label class="col-sm-2 control-label">profile</label> <div class="col-sm-8"> <select ng-model="user.userdata.profile" ng-options="person._id person.profilename person in user.profile"> </select> </div> hierarchy of vm.profile { "_id": 46, "profile": objectid("5516498e95b84548156db754"), "isactive": true, "password": "$2...
Read more

qt - Change color of QGraphicsView rubber band -

-
i know it's possible change color of rubber band rectangle way: qrubberband rubberband = new qrubberband(qrubberband::rectangle, this); qpalette pal; pal.setbrush(qpalette::highlight, qbrush(qt::white)); rubberband->setpalette(pal); but here way achieve rubber band, rendered qgraphicsview when rubberbanddrag mode active? or in "global scope"? i'm sorry wrote question, i've looked solution long time, , nothing. few minutes after asking, found solution setting stylesheet. i'm sharing it. just go designer of qt creator, click on canvas (qgraphicsview). in "qwidget" part find "stylesheet", edit it, , put like: selection-background-color: rgba(255, 255, 255, 128); that's :-). thanks.
Read more

c++ - Print Preview in Qt -

-
i want preview page or want have print preview. preview window opening contents of qt window not comming in it. code print preview follows: void user::on_actionprintpreview_triggered() { qprinter printer(qprinter::highresolution); qprintpreviewdialog preview(&printer, this); connect(&preview, signal(paintrequested(qprinter *)), this, slot(print(qprinter *))); preview.exec(); } void user::print(qprinter *printer) { // print page qpainter painter(printer); int w = printer->pagerect().width(); int h = printer->pagerect().height(); qrect page(0, 0, w, h); qfont font = painter.font(); font.setpixelsize((w+h)/100); painter.setfont(font); painter.drawtext(page, qt::alignbottom | qt::alignright, qdatetime::currentdatetime(). tostring(qt::defaultlocaleshortdate)); page.adjust(w/20, h/20, -w/20, -h/20); } how can content of qt window in it. doing wrong. please m...
Read more