Variant of SQL used in the Apache Hive data warehouse infrastructure.
My question is : Is there a way to do find the last day of a month in Hive, like Oracle …
sql hive hiveqlI'm having a table in MySQL viz. nas_comps. select comp_code, count(leg_id) from nas_comps_01012011_31012011 n group …
hive hiveqlI am working with Impala and fetching the list of tables from the database with some pattern like below. Assume …
hive cloudera hiveql cloudera-cdh impalaBasically i would like to return rows based on one column value. If the column contains non numeric values, then …
hive hiveqlI have created a table couple months ago. Is there any way in HIVE that I can see when was …
hive hiveqlI am getting this error while performing a simple join between two tables. I run this query in Hive command …
hive hiveql datastax-enterprise cassandra-2.0I have a database people in hive. It's schema is as follows: name string, dob_date int, dob_month int, …
hive hiveqlI am not able to understand what this DISTRIBUTE BY clause does in Hive. I know the definition that says, …
hive hiveql hadoop2For a student database in the following format Roll Number | School Name | Name | Age | Gender | Class | Subject | Marks How to …
group-by hive hiveql