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 - hive

How to parse in the varchar type json column?

Can you tell me how to parse in varchar type? (in Presto & Hive) [{u'pageId': u'102', u'title': u'ud648', u'isBrandHomePage': 1, u'active': True, u'pageType': 1, u'type': u'page'}, {u'pageId': u'1...
test-img

Sun

json

parsing

hive

presto

varchar

Votes: 0

Answers: 1

Latest Answer

Parsing in Hive: convert JSON to valid one, remove [], split on records, use json_tuple: with mytable as ( select "[{u'pageId': u'102', u'title': u'ud648', u'isBrandHomePage': 1, u'active': True...
test-img

leftjoin

unable to create internal hive table

i am getting below error while trying to create hive internal table CREATE TABLE employee(id INT,Name STRING); FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. Met...
test-img

Raja

hadoop

installation

hive

ubuntu-20.04

Votes: 0

Answers: 0

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

Create a hive table using python

I am using python and I want to create a hive table. Also I want that table should be created with same data type as of data type in dataframe; Below is the code I used to create a connection with hiv...
test-img

KMittal

python

hive

pyodbc

impala

Votes: 0

Answers: 0

Posts

Questions

Blogs

Jobs