Questions tagged [hiveql]
HiveQL is an SQL-like language for data summation, query, and analysis for use with Apache Hive, a data warehouse infrastructure built on top of Hadoop. HiveQL queries are automatically converted into map-reduce jobs.
4
questions
1
vote
0
answers
419
views
Creating Quantile Cutoffs using SQL Hive
I have a table in Hadoop that looks like this (with up to hundreds of columns and millions of rows):
...
- 83
2
votes
1
answer
17k
views
Regex in Hive QL (RLIKE)
I'm wondering how/if I can improve the regex I'm using in a query. I have a set of identifiers for certain user groups. They can be in two main format:
X123 or <...
- 123
5
votes
2
answers
1k
views
Writing a hiveserver2 query result to CSV with Python using pyhs2
I am trying to create a small application that will help me extract data from Hadoop via hiveserver2 by simply writing it to CSV. At the moment, it takes about 40 seconds to pull 10,000 records from a ...
- 51
5
votes
1
answer
3k
views
Change Data Capture using HIVE
Could you please review my code and let me know if there is something wrong? I'm getting the expected results.
I'm trying to do change data capture using hive. We already have an existing CDC in ...
- 53