Reply
New Contributor
Posts: 1
Registered: ‎05-22-2018

Impala data reduction based on time value

I'm looking for a solution to restrict my data table based on year. What is the correct syntax for achieving this?

 

SELECT [column] FROM database IN('yyyy')

 

Help please :) 

Expert Contributor
Posts: 105
Registered: ‎07-17-2017

Re: Impala data reduction based on time value

Hi @Kath,

What the type of the column you want to restrict it? is it a TIMESTAMP column?
If it's a TIMESTAMP or STRING try to use this:

select [column] from [table] where extract(year from [column]) is not null;


Good luck.

Announcements