Re: Creating View Table Using the Date & Time

Ok, Thank you very much for the help. On Wed, Feb 14, 2018 at 12:43 PM, James Taylor wrote: > No, you’ll need to create a Phoenix table and use Phoenix APIs to write > your data. > > On Tue, Feb 13, 2018 at 9:52 PM Vaghawan Ojha > wrote: > >>

Re: Creating View Table Using the Date & Time

No, you’ll need to create a Phoenix table and use Phoenix APIs to write your data. On Tue, Feb 13, 2018 at 9:52 PM Vaghawan Ojha wrote: > Thank you James, my keys are something like > this: 2018-02-01-BM50558-1517454912.0-5-1517548497.261604 . the first few > chars are

Re: Creating View Table Using the Date & Time

Thank you James, my keys are something like this: 2018-02-01-BM50558-1517454912.0-5-1517548497.261604 . the first few chars are the date. and these dates are stored in a seperate columns as BDATE as well. Do you think I could implement the rowtimestamp in the BDATE column? Thanks Vaghawan On

Re: Creating View Table Using the Date & Time

Yes, the datetime column is part of my primary key, but primary key also consists other strings. Thanks Vaghawan On Tue, Feb 13, 2018 at 11:05 PM, James Taylor wrote: > The standard way of doing this is to add a TTL for your table [1]. You can > do this through the

Re: Creating View Table Using the Date & Time

The standard way of doing this is to add a TTL for your table [1]. You can do this through the ALTER TABLE call [2]. Is the date/time column part of your primary key? If so, you can improve performance by declaring this column as a ROW_TIMESTAMP [3]. A view is not going to help you - it's not