[jira] [Commented] (PHOENIX-5679) Querying a DATE column with 'YYYY-MM-DD HH:MM:SS' format not returning the right data

2020-02-13 Thread Sandeep Guggilam (Jira)
[ https://issues.apache.org/jira/browse/PHOENIX-5679?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17036455#comment-17036455 ] Sandeep Guggilam commented on PHOENIX-5679: --- Discussed with [~larsh] offline. We can use

[jira] [Commented] (PHOENIX-5679) Querying a DATE column with 'YYYY-MM-DD HH:MM:SS' format not returning the right data

2020-01-16 Thread Lars Hofhansl (Jira)
[ https://issues.apache.org/jira/browse/PHOENIX-5679?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17017632#comment-17017632 ] Lars Hofhansl commented on PHOENIX-5679: I don't think we can just redefine the Phoenix data

[jira] [Commented] (PHOENIX-5679) Querying a DATE column with 'YYYY-MM-DD HH:MM:SS' format not returning the right data

2020-01-16 Thread Sandeep Guggilam (Jira)
[ https://issues.apache.org/jira/browse/PHOENIX-5679?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17017509#comment-17017509 ] Sandeep Guggilam commented on PHOENIX-5679: --- [~larsh] We could probably change the

[jira] [Commented] (PHOENIX-5679) Querying a DATE column with 'YYYY-MM-DD HH:MM:SS' format not returning the right data

2020-01-16 Thread Lars Hofhansl (Jira)
[ https://issues.apache.org/jira/browse/PHOENIX-5679?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17017503#comment-17017503 ] Lars Hofhansl commented on PHOENIX-5679: We can fix it with: !set dateFormat "-MM-dd

[jira] [Commented] (PHOENIX-5679) Querying a DATE column with 'YYYY-MM-DD HH:MM:SS' format not returning the right data

2020-01-16 Thread Lars Hofhansl (Jira)
[ https://issues.apache.org/jira/browse/PHOENIX-5679?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17017498#comment-17017498 ] Lars Hofhansl commented on PHOENIX-5679: See: 

[jira] [Commented] (PHOENIX-5679) Querying a DATE column with 'YYYY-MM-DD HH:MM:SS' format not returning the right data

2020-01-16 Thread Lars Hofhansl (Jira)
[ https://issues.apache.org/jira/browse/PHOENIX-5679?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17017494#comment-17017494 ] Lars Hofhansl commented on PHOENIX-5679: Looks like we're on sqlline 1.5.0, 1.9.0 was just

[jira] [Commented] (PHOENIX-5679) Querying a DATE column with 'YYYY-MM-DD HH:MM:SS' format not returning the right data

2020-01-16 Thread Lars Hofhansl (Jira)
[ https://issues.apache.org/jira/browse/PHOENIX-5679?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17017425#comment-17017425 ] Lars Hofhansl commented on PHOENIX-5679: Hence sqlline does the right thing for SQL 92, but now

[jira] [Commented] (PHOENIX-5679) Querying a DATE column with 'YYYY-MM-DD HH:MM:SS' format not returning the right data

2020-01-16 Thread Lars Hofhansl (Jira)
[ https://issues.apache.org/jira/browse/PHOENIX-5679?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17017424#comment-17017424 ] Lars Hofhansl commented on PHOENIX-5679: The doc says this: "Please note that this {{DATE}} 

[jira] [Commented] (PHOENIX-5679) Querying a DATE column with 'YYYY-MM-DD HH:MM:SS' format not returning the right data

2020-01-16 Thread Lars Hofhansl (Jira)
[ https://issues.apache.org/jira/browse/PHOENIX-5679?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17017417#comment-17017417 ] Lars Hofhansl commented on PHOENIX-5679: Hmm... There's DATA and DATATIME, right? (not sure

[jira] [Commented] (PHOENIX-5679) Querying a DATE column with 'YYYY-MM-DD HH:MM:SS' format not returning the right data

2020-01-15 Thread Sandeep Guggilam (Jira)
[ https://issues.apache.org/jira/browse/PHOENIX-5679?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17016434#comment-17016434 ] Sandeep Guggilam commented on PHOENIX-5679: --- There is a change in sqlline recently where they