Hi All,

I want use hadoop tools for pentaho integration,

firtsly, i want use hive as datasource, but few times ago i knew that Hive doesn't support mdx, so i think to use Mysql as database.

Now i want to make schema like below


/ Server 3 ---------------\
Mysql --- >> PDI -->> hadoop -- Server 1 ------------------(map reduce) > Mysql >> reporting / analysis
\ Server 2 --------------- /


From that we know that, i want to process data from Mysql use PDI in ETL processing, then data after have process map/reduce will Insert to Mysql again as result table of summarization,


Is PDI can do that ? and how transfer data result from hdfs to mysql again use PDI ?

help me please ..