I am trying to insert mssql data into parquet table on impala using nifi. I used executesql->PutdatabaseRecord but it is so slow. Then i used attributes and replacetext processors. I sent 'INSERT INTO X VALUES (1,'XX'),(2,'YY')' to PutSQL or ExecuteSQL processors(maybe I thought it might be faster than putdatabaserecord) but it's slow.
How can i insert data into parquet table more faster?