Profile

Alberto Garcia

Ecotisa Una Tinta de Impresin S.L.U.

Contact Details

Ecotisa Una Tinta de Impresin S.L.U.

My Content

1 to 3 of 3 total

RE: googledrive-vfs

Posted By Alberto Garcia 02-03-2023 02:12
Found In Community: Pentaho \ view thread
Hey! Maybe a bit late for this, but although the Pentaho-Google-Sheet-Plugin is great... it only writes data with the correct format when using all strings and it doesn't let you select the folder for your new spreadsheets. What I did was installing the google drive app for desktop, to have a virtual ...

RE: How to handle huge(500-600 mn rows) records in PDI

Posted By Alberto Garcia 10-25-2022 08:03
Found In Community: Pentaho \ view thread
Hello @Samarth Shah, one way I did it was with custom pagination. At first I tried this typical SQL pagination (in PostgreSQL), building a loop inside the parent Job (against PDI warning): SELECT * FROM table_name OFFSET $(PAGE_OFFSET) ORDER BY id LIMIT $(PAGE_SIZE)​ Then in the loop you can set the ...

RE: Select current datetime from Database instead of PDI server time using Table Input step

Posted By Alberto Garcia 10-25-2022 07:56
Found In Community: Pentaho \ view thread
Actually, it does have to be with PDI. One way of setting it, it's going to your spoon.sh / spoon.bat file, and adding this argument to the java options. In my case, in Ubuntu, I added this "-Duser.timezone=UTC" at the end of the "OPT" variable declaration. WARNING: This will set the timezone for all ...