Question: ##Filter the data using Spark SQL id query = SELECT warc.server, warc. date FROM warc WHERE warc.date ' 2 0 1 7 -
##Filter the data using Spark SQL
id query "SELECT warc.server, warc. date
FROM warc
WHERE warc.date T::Z and warc.date T::Z
This query works but the SORT BY does not work
##Filter the data using Spark SQL
id query "SELECT warc.server, warc.date
FROM warc
WHERE warc.date T::Z and warc.date T::Z
ORDER BY warc. date ASC"
warc.date is timestamp ex::
Do I need to do any conversion of the timestamp
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
