Working with xm files

[Shashidhar Rao <ra...@gmail.com>]

Hi,

Can somebody help me with this use case.

I need to store large amount of xml files. I plan to convert these xml
files into json and then store into Mongodb or Hbase. The use Apache drill
to query the data.

Or is it possible to directly store xml into HDFS and query the xml using
apache drill.

Please let me know the best practice. All I need is to query the data in
the xml and put up a dashboard e.g like top 10 products etc

Regards
Niranjan

Re: Working with xm files

[Yash Sharma <ya...@gmail.com>]

Hi Niranjan,
There is no direct support for querying XML files via Drill yet - but there
are two things I can think on top of my mind for your use case.

1. Use Hive to load Xml data and query the hive table via Drill
2. Convert the Xml to Json by any mechanism of your choice and query the
Json file via Drill directly (or insert the Json to Mongo and query mongo)

Also, would you like to contribute to Drill Xml Reader ? It would be a nice
feature for users.




On Mon, Jan 5, 2015 at 11:01 AM, Shashidhar Rao <ra...@gmail.com>
wrote:

> Hi,
>
> Can somebody help me with this use case.
>
> I need to store large amount of xml files. I plan to convert these xml
> files into json and then store into Mongodb or Hbase. The use Apache drill
> to query the data.
>
> Or is it possible to directly store xml into HDFS and query the xml using
> apache drill.
>
> Please let me know the best practice. All I need is to query the data in
> the xml and put up a dashboard e.g like top 10 products etc
>
> Regards
> Niranjan
>