Re: Hive 2 Metastore Entity-Relationship Diagram, Base tables

for now to be used as a quick reference for hive metadata tables, columns, pk and constraint. It only covers the base tables excluding transactional add ons in hive-txn-schema-2.0.0.oracle.sql HTH Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6

Re: Hive 2 Metastore Entity-Relationship Diagram, Base tables

What capability is this construct designed to support? Reporting, ad hoc query? I need a context. Regards, Denise Cell - (860)989-3431 Sent from mi iPhone > On May 22, 2016, at 3:36 AM, Mich Talebzadeh > wrote: > > > Hi, > > This is Hive 2 Entity-Relationship Diagrams created by running t

Re: Hive and XML

XML is generally slow in any software. It is not recommended for large data volumes. > On 22 May 2016, at 10:15, Maciek wrote: > > Have you had to load XML data into Hive? Did you run into any problems or > experienced any pain points, e.g. complex schemas or performance? > > I have done a lo

Re: Hive and XML

That is interesting. DBs like MarkLogic are adapt to this. BTW how do you define yor base Hive table for XML and what table type have you used? HTH Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw

Hive and XML

Have you had to load XML data into Hive? Did you run into any problems or experienced any pain points, e.g. complex schemas or performance? I have done a lot of research on the role of XML in Big Data analytics recently and would like to get your view on it. It would be very helpful if you could f