python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - hiveql

How can i add days to a Hive timestamp without loosing hours, minutes and seconds

I am using Hive 2.6.5 and when i want to add days to my timestamp, it doesn't keep the hours, minutes and seconds. Exemple SELECT from_unixtime(unix_timestamp(date_add("2021-01-15 09:34:21",...
test-img

Azo

sql

hive

timestamp

hiveql

Votes: 0

Answers: 1

Latest Answer

date_add truncates Unnecessary unix_timestamp+from_unixtime conversion Convert to timestamp, add interval: SELECT timestamp("2021-01-15 09:34:21") + interval '2' day; Result: 2021-01-17 0...
test-img

leftjoin

concat regex specific columns hive sql

I have a table having columns __word__|__f0__|__f1__|__f2__|__..__|__f99__| .. | .. | .. | .. | .. | ... | columns f0-f99 have real numbers (vector embeddings of the word). I want to ...
test-img

Hassam

sql

database

hive

hiveql

Votes: 0

Answers: 0

What is difference between where and join in Hive SQL when joining two tables?

For example, -- use WHERE SELECT a.id FROM table_a as a, table_b as b WHERE a.id = b.id; -- use JOIN SELECT t1.id FROM ( SELECT id FROM ...
test-img

Bowen Peng

sql

join

hive

hiveql

Votes: 0

Answers: 1

Latest Answer

Join like this FROM table_a as a, table_b as b WHERE a.id = b.id; is a bad practice because in general, WHERE is being applied after join and transforming it to JOIN and pushing predicate...
test-img

leftjoin

Hive Double and Decimal value incorrect format

I am migrating the sql statement greenplum to HiveSQL supported with pyspark scripts. we are encounter the issues if the double or decimal value, the value getting changed while doing the sum of the d...
test-img

Developer KE

pyspark

hive

hiveql

greenplum

Votes: 0

Answers: 0

Posts

Questions

Blogs

Jobs