Search Options
Skip to main content (Press Enter).
Sign In
Skip auxiliary navigation (Press Enter).
Skip main navigation (Press Enter).
Toggle navigation
Search Options
Communities
General Discussion
My Communities
Explore All Communities
Products
Solutions
Services
Developers
Champions Corner
Customer Stories
Insights
Become an Advocate
Badge Challenges
Resources
Resource Library
Hitachi University
Product Documentation
Product Downloads
Partners Portal
How To
Get Started
Earn Points and Badges
FAQs
Start a Discussion
Profile
My Contributions
List of Contributions
Profile
Alberto Garcia
Ecotisa Una Tinta de Impresin S.L.U.
Contact Details
Ecotisa Una Tinta de Impresin S.L.U.
×
Enter Password
Enter Password
Confirm Password
Alberto Garcia
Ecotisa Una Tinta de Impresin S.L.U.
Profile
Connections
Contacts
Contributions
Badges
List of Contributions
My Content
1 to 3 of 3 total
search criteria =
ALL
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 ...
© Hitachi Vantara LLC 2023. All Rights Reserved.
Powered by Higher Logic