tips and tricks

To export workbook  curl -u <user>:<pass> -X GET http://<datameer_server>:8080/rest/workbook/<workbookid> > <fil_name>.json To import workbook:  curl -u <user>:<pass> -X POST -d @<file_name>.json...

fuser -dV <path&...

Although it seem hard and complicated. Once you discovered correct connection string and driver name getting data out of Informatica file archive with sqoop is pretty simple and straightforward. Unfortunately due to structure there is no way to specify...

Hi All; With new CDH versions class name for HCatalog loader changed. Unfortunately this is not documented clearly. Just change org.apache.hcatalog.pig.HCatLoader to org.apache.hive.hcatalog.pig.HCatLoader in your pig scripts to solve problem. I...

Here is a list of instructions to upgrade Datameer.  It is basically unzip the new Datameer version into a new folder and copy over several files to the new version. Then you run a script that upgrades HSQLDB.  Step 0: Save all Datameer...

Depending on java configuration Sqoop2 database creation may fail to update derby drivers and may get "Failed to execute command Create Sqoop Database on service Sqoop 2" error. To solve this apply following steps: 1. Download derby derby client from db-derby-10.11.1.1-bin.zip 2....

You can use following SQL to query "Automatically deactivate when finished" status from UC4 repository. select OH_IDNR, OH_NAME, CASE      WHEN JBA_AUTODEACT = 'A' THEN 'Always'     WHEN JBA_AUTODEACT = 'J' THEN 'After error-free...