python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - hiveql

hiveQL query select classID, studName from table1 where grade = Max(grade) group by classID, studName;

Sorry for writing an obvious bad query in subject but it accurately describes the result I am looking for. I have a table with classID int, studName string, grade int. I need a result that lists each ...
test-img

swade77

hadoop

hive

hiveql

Votes: 0

Answers: 1

Latest Answer

Issue with your SQL - You need to name the max column and then use it in subquery IN clause. change the view like below. CREATE VIEW newView as select classID, MAX(grade) as maxgrade from table1 group...
test-img

Koushik Roy

How to transform data in Amazon Athena

I have some data in S3 location in json format. It have 4 columns val, time__stamp, name and type. I would like to create an external Athena table from this data with some transformations given below:...
test-img

ndev

amazon-web-services

hive

hiveql

amazon-athena

Votes: 0

Answers: 2

Latest Answer

You can create you own UDF for transformation and use it in Athena. https://docs.aws.amazon.com/athena/latest/ug/querying-udf.html
test-img

Ashutosh gupta

How can I create a table if it doesn't exist, else alter the table schema to match in HiveQL

I have an automated workflow that essentially builds out a table from a bunch of other existing tables. We get asks to add new fields to that and other tables relatively frequently. Currently I have t...
test-img

user105189

sql

hiveql

Votes: 0

Answers: 1

Latest Answer

For modifying the initial/PARENT table, I'm afraid there's no other way but to specify the new columns manually. If other tables depend on the parent table, you can utilize select * to include the new...
test-img

Clover

I need a column which replace DATETIME to amount of hours that passed till then

SELECT barcode ,location ,updated FROM ( SELECT order_reference AS barcode ,mth.location AS location ,mth.last_update_ts AS updated ,row_number() OVER ( ...
test-img

Pat

sql

hiveql

Votes: 0

Answers: 0

Posts

Questions

Blogs

Jobs