Amazon Redshift Spectrum supports DATE Data Type

Amazon Redshift Spectrum can be now be used to query DATE data type stored in the enhanced Row Columnar (ORC) and text the file in Amazon S3. You can also utilize the DATE data type to query clickstream data within particular time windows to receive insights into the business trends. Amazon Redshift Spectrum is a feature of the Amazon Redshift that expands the analytics to data stored in the Amazon S3 data lake utilizing the open file formats the users are already using with no transformation and no loading needed. You can now simultaneously utilize the same standard SQL of the Amazon Redshift and the Business Intelligence tools you utilize today. Amazon Redshift spectrum implements practical query optimization and scales processing potentially across on thousands of nodes to give you fast results and high concurrency even with complex queries and large datasets. Amazon Redshift Spectrum offers you the freedom to store your data where you want or in the format, you want and can have it available for processing whenever is needed it.