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
RE: Using hiveSQL to find content