python (65.2k questions)

javascript (44.3k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (13k questions)

Questions - hive

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

What does gradle classifier: 'core'?

I had conflict with the protobuf dependency of hive and another package that depends on protobuf. I solved the problem with "classifier: 'core'": implementation group: 'org.apache.hive', nam...
test-img

Paulo Moreira

java

gradle

hive

protobuf-java

Votes: 0

Answers: 1

Latest Answer

put simply its another filter criteria to get a sub-type for a GAV artifact in maven repository. useful when there are multiple flavours for a single artifact. Ex: jar per JDK version see more https:/...
test-img

PrasadU

Hive GROUP BY optimization based on cardinality

Logically cardinality of columns should matter while doing GROUP BY operation. When we write Hive queries involving GROUP BY, since we are familiar with the data being queried, we have an idea about c...
test-img

Dhiraj

group-by

hive

Votes: 0

Answers: 0

Best way to cache pictures in flutter app?

I have created an app using dart/Flutter where users are able to store photos. These photos are stored in FireStorage but every time the app opens it takes a while until all photos are loaded due to t...
test-img

A.Ktns

flutter

dart

caching

hive

firebase-storage

Votes: 0

Answers: 2

Latest Answer

You can use this package Cached network image CachedNetworkImage( imageUrl: "http://via.placeholder.com/350x150", progressIndicatorBuilder: (context, url, downloadProgress) =...
test-img

Ashutosh Patole

Posts

Questions

Blogs

Jobs