TY - CHAP A1 - Pilven, Matthieu A1 - Scherzinger, Stefanie A1 - d’Orazio, Laurent ED - Guizzardi, Giancarlo ED - Gailly, Frederik ED - Suzana Pitangueira Maciel, Rita T1 - On Complex Value Relations in Hive T2 - Advances in Conceptual Modeling, ER 2020 workshops CMAI, CMLS, CMOMM4FAIR, CoMoNoS, EmpER, Vienna, Austria, November 3-6, 2020, Proceedings N2 - In this paper, we raise the question how data architects model their data for processing in Apache Hive. This well-known SQL-on-Hadoop engine supports complex value relations, where attribute types need not be atomic. In fact, this feature seems to be one of the prominent selling points, e.g., in Hive reference books. In an empirical study, we analyze Hive schemas in open source repositories. We examine to which extent practitioners make use of complex value relations and accordingly, whether they write queries over complex types. Understanding which features are actively used will help make the right decisions in setting up benchmarks for SQL-on-Hadoop engines, as well as in choosing which query operators to optimize for. KW - Complex value relations KW - Empirical study KW - Hive Y1 - 2019 SN - 978-3-030-34145-9 U6 - https://doi.org/10.1007/978-3-030-34146-6_13 SP - 146 EP - 156 PB - Springer International Publishing CY - Cham ER -