hiveql-CodePudding

Tags > hiveql

08-29databaseHow to get distinct count over multiple columns in Hive SQL?
07-24Back-endHive Increase in bucket count- how the existing data split occurs to new buckets?
07-15NetGrouping using row number function
06-30Software engineeringhive join tables and create 2 different tables
06-23Software designOracle database query tuning
06-18OSfind the min date (Closest to current date) if dates lies in future date and max date (closest to cu
06-03Mobilecount most repeated value per group in hive?
05-31OSHow to pass env variable in hive script?
05-28front endIdentify the second max value in hive based on condition
05-11databaseHive SQL: How to create flag occurrence while join with other table
05-11OSSelect rows without the maximum amount or rows from grouping
04-27NetHQL, insert two rows if a condition is met
04-09NethiveQL query select classID, studName from table1 where grade = Max(grade) group by classID, studNam
04-08OSHow to transform data in Amazon Athena
03-18Software designSQL query conversion to Hive supported migration SQL
03-16Software engineeringHow to convert a hive query with regex to oracle
03-16databaseHow to add delimiter to String after every n character using hive functions?
03-04Software designgenerate Highest Number from the given Input and replacing 0 by 9 using hive
03-04Back-endHive Substring from complex subquery
03-02Software engineeringCOUNT with CASE WHEN is showing the same result when using division
02-25Back-endHow to extract all characters between last and second last spaces?
12-20otherTimestamp string conversion / from_utc_timestamp
12-13databaseIs it possible to use/query data using Pig/Tableau or some-other tool from HDFS which was inserted/l
12-13otherhow to remove duplicated records depend on column not able to sort in hive
12-06MobileHow to convert date column value which is in CST timezone
12-06MobileHow to convert date column value which is in CST format
12-05Software engineeringHive Reading only one json row
12-04front endFind session start and end info from logs
12-03front endInformix to HiveQL
11-26Software engineeringHive "insert into" doesnt add values
11-23Netcount number of times a regex pattern occurs in hive
11-23MobileGet full data view for two tables in Hive?
11-22Software engineeringGet last matched value after backslash in Hive
11-19Back-endHive regexp_extract numeric value from a string
11-16BlockchainHow to return array<struct> from json_tuple in hive
11-16Enterpriseuser level session_start_time and session_end time from clickstream data
11-14front endFill a column in sql table with the number of unique values of a column from other table
11-11BlockchainHow to insert from one hive table to another using select for one column
11-07Software designCount records per year and month based on date & id
11-05Software designTimestamp parsing in Hive

55 1 2 Next Last