News for hackers. Stuff that matters.
Re:Apache Drill 1.0 – Schema-Free SQL Query Engine for Hadoo... by polskibus on Tuesday May 19, 2015 @03:01PM (#9572323)
How does Apache Drill compare to Power Pivot/ Power Query? As far as I understand, both aim to solve the problem if heterogeneous data sources. What I don't understand is how they differ.
Re:Apache Drill 1.0 – Schema-Free SQL Query Engine for Hadoo... by IndianAstronaut on Wednesday May 20, 2015 @01:20AM (#9574799)
I'm not sure power pivot deals well with heterogeneous data sources. It rests on OLAP services which rely on a fixed star schemas in a data warehouse. Power pivot is just a front end for MDX(multi-dimensional expression) queries.