Tuesday, March 22, 2016

xlsx file limit in Talend

Hello All,
You can only dump maximum  10,48,576 rows into ms excel (xlsx) file using talend.

Sample Error MSG:

Exception in component tFileOutputExcel_1
java.lang.IllegalArgumentException: Invalid row number (1048576) outside allowable range (0..1048575)
    at org.apache.poi.xssf.streaming.SXSSFSheet.createRow(SXSSFSheet.java:107)

Friday, March 4, 2016

Know the table create and update date and time in mysql

How to know the last date and time of table insert and update

below is the syntax, you can use to see last table created date and time-

show table status from DBNAme like 'tableName'

output-