RE: RE: Using hiveSQL to find content
You are viewing a single comment's thread from:

RE: Using hiveSQL to find content

dalz(81)
Published in
STEMGeeks
Words
19
Reading
1 min
Listen
Play
6y

SELECT
timestamp,
json_metadata

FROM Txcustoms
WHERE 
CONVERT(DATE,timestamp) BETWEEN '2020-12-01' AND '2021-02-28'
AND [tid] in ('ssc-mainnet-hive')
AND [json_metadata] like ('%"DEC"%')
AND [json_metadata] like ('%"null"%')

I use this query for DEC transfers to null ... you need to parse the json data as well

@dalz: SELECT timestamp, | Ecency