php - Bigquery query failure handling -

-

i trying make sure streaming queries inserted successfully, , seems though of these queries not being inserted correctly.

there no errors being thrown not using data returned insert request not know how errors structured.

here insertion code:

    $rows = array();     $row = new google_service_bigquery_tabledatainsertallrequestrows;     $row->setjson($data);     $rows[0] = $row;     $request = new google_service_bigquery_tabledatainsertallrequest;     $request->setkind('bigquery#tabledatainsertallrequest');     $request->setrows($rows);     return $this->service->tabledata->insertall($project, $dataset, $tableid, $request);

the above code excludes authentication/setting client & service

you can use method

/**  *   * @param google_client $client  * @param type $project_id  * @param type $dataset_id  * @param type $rows  * @return mixed  * @throws google_service_exception  */ public function bq_tabledata_insertall($client, $project_id, $dataset_id, $rows) {     $success = true;     $failed_lines = array();     $last_reason = '';     $ret = array(         'success' => &$success,         'last_reason' => &$last_reason,         'failed_lines' => &$failed_lines,     );     $bq = new google_service_bigquery($client);     $request = new google_service_bigquery_tabledatainsertallrequest();     $request->setrows($rows);     try {         $resp = new google_service_bigquery_tabledatainsertallresponse();         $resp = $bq->tabledata->insertall($project_id, $dataset_id, static::tableid(), $request);         $errors = new google_service_bigquery_tabledatainsertallresponseinserterrors();         $errors = @$resp->getinserterrors();         if (!empty($errors)) {             $error_msg = "\r\nrequest headers: \r\n" . json_encode($client->request->getrequestheaders()) . "\r\nresponse headers: \r\n" . json_encode($client->request->getresponseheaders()) . "\r\nrequest body:\r\n" . $client->request->getpostbody() . "\r\nresponse body:\r\n" . $client->request->getresponsebody() . "\r\n";             if (is_array($errors)) {                 foreach ($errors $ep) {                     $arr = $ep->geterrors();                     $line = $ep->getindex();                     if (is_array($arr)) {                         foreach ($arr $e) {                             switch ($e->getreason()) {                                 case "stopped":                                     break;                                 case "timeout":                                     $failed_lines[] = $line;                                     $last_reason = $e->getreason();                                     $error_msg.= sprintf("timeout on line %s, reason: %s, msg: %s\r\n", $line, $e->getreason(), $e->getmessage());                                     break;                                 default:                                     $error_msg.= sprintf("error on line %s, reason: %s, msg: %s\r\n", $line, $e->getreason(), $e->getmessage());                                     break;                             }                         }                     } else {                         $error_msg.= json_encode($arr) . "\r\n";                     }                 }                 $this->seterrormessage($error_msg);             } else {                 $this->seterrormessage($errors);             }             //print_r($errors);             //exit;             $success = false;         }         return $ret;     } catch (google_service_exception $e) {         $this->seterrors($e->geterrors())->seterrormessage($e->getmessage());         throw $e;     } }

Comments

Post a Comment

Popular posts from this blog

java - Could not locate OpenAL library -

-
i writing game using slick2d library, uses lwjgl. lwjgl version 2.9.3. using netbeans 8. i tried adding sounds game, example music track on main menu. problem is, exception when run game, despite game still compiling , running except sound of course: sat mar 21 01:23:57 edt 2015 error:could not locate openal library. org.lwjgl.lwjglexception: not locate openal library. @ org.lwjgl.openal.al.create(al.java:156) @ org.lwjgl.openal.al.create(al.java:156) @ org.lwjgl.openal.al.create(al.java:102) @ org.lwjgl.openal.al.create(al.java:206) @ org.newdawn.slick.openal.soundstore$1.run(soundstore.java:295) @ java.security.accesscontroller.doprivileged(native method) @ org.newdawn.slick.openal.soundstore.init(soundstore.java:292) @ org.newdawn.slick.music.<init>(music.java:156) @ org.newdawn.slick.music.<init>(music.java:75) @ view.mainmenu.init(mainmenu.java:58) i didn't include rest of error states error happens in game code. the...
Read more

c++ - Delete matches in OpenCV (Keypoints and descriptors) -

-
i want check scene image against 2 train images. that, detect features , compute descriptors of both training images. before detecting, computing , matching scene image, delete matches of train1 , train2. because these matches won't facilitate matching of scene image train1 , train2. so, match train1 train2 , vector of matches trainidx , queryidx. how can delete these matches in keypoints-vector , descriptor matrix of train1 , train2? best regards, dwi i have done below: std::vector<cv::keypoint> keypoints[2]; cv::mat descriptor[2]; std::vector< cv::dmatch > matches; /* write code generate keypoints, descriptors , matches here... keypoint[0] -> train image 1 keypoints keypoint[1] -> train image 2 keypoints descriptor[0] -> train image 1 descriptors descriptor[1] -> train image 2 descriptors matches -> matched between train image 1 , 2 */ // logic keep unmatched keypoints , corresponding descriptor...
Read more

sorting - opencl Bitonic sort with 64 bits keys -

-
i used nvidia sdk bitonic sort , works great me. 32 bits (uint) need ulong keys. have typically 2^14 keys @ time , power of 2. searched on not find kernel designed ulong. i tried modified nvidia sdk bitonic sort using ulong keys not work. kernel not crash after de call clenqueuendrangekernel got error : cl_invalid_command_queue can tell me how modify bitonic sort or radixsort, or can sort ulong keys? i running nvidia quadro 4000 opencl 1.1 cuda 6.5.20 full_profile used original nvidia sdk bitonicsort.cl i used"ulong" keys , value input , ouput instead of "uint" thanks helping i made work-around suit need. used 30 bits of key , 18 high bits of value sorting. changed comparators (2 lines): '#define mask 0xffffc000 // suit need from this: if( (*keya > *keyb) == dir ) this: if(((*keya > *keyb)||((*keya == *keyb)&&((*vala & mask)> (*valb & mask)))) == dir ) it works fine. but, still, it's work-a...
Read more