Any JIRA yet, Marek? It'd be good to get to the bottom of this. Your
work around is not going to perform nearly as well as using TRUNC on
the date.
Thanks,
James
On Tue, Apr 7, 2015 at 8:53 AM, James Taylor jamestay...@apache.org wrote:
Yes, please open a JIRA and attach that CSV (or ideally the
Hi James - I'm sorry for delay I had to troubleshoot some other more urgent
issue.
I will try to open JIRA with a sample CSV today.
Thanks!
Marek
2015-04-08 23:08 GMT+02:00 James Taylor jamestay...@apache.org:
Any JIRA yet, Marek? It'd be good to get to the bottom of this. Your
work around
Hi James - shall I still open a JIRA for that?
Thanks!
Marek
2015-04-06 22:48 GMT+02:00 Marek Wiewiorka marek.wiewio...@gmail.com:
psql from a csv file:
./psql.py dwh:2181:/hbase-unsecure -t SE_DWH.HOMES_USAGE_HOUR
/mnt/spark/export/usage_convert.txt/usage_merged.csv
Here is a sample:
Hi Marek,
How did you input the data and what does your CREATE TABLE/VIEW
statement look like? What version of Phoenix and HBase are you using?
Also, would you mind running the following query and letting us know the output?
select to_char(hu_ts,'-MM-dd
That certainly looks like a bug. Would it be possible to make a small
reproducible test case and if possible, log this in the Phoenix JIRA (
https://issues.apache.org/jira/browse/PHOENIX) ?
- Gabriel
On Mon, Apr 6, 2015 at 6:10 PM Marek Wiewiorka marek.wiewio...@gmail.com
wrote:
Hi All,
I
Hi Marek,
Thanks for the additional information. If you could answer my earlier
questions, that would be helpful.
If you can't repro with a simple test case, then how about attaching a
csv dump of some of your data (the smallest amount of data that repros
the issue) to a JIRA along with the
How did you input the data?
On Mon, Apr 6, 2015 at 1:27 PM, Marek Wiewiorka
marek.wiewio...@gmail.com wrote:
Oh I'm sorry I forgot to attach them:
DDL of my table:
create table se_dwh.homes_usage_hour (hu_ts time not null ,hu_ho_id integer
not null ,hu_stream_id integer not null, hu_usage
Hi James - sure here is the result of your query (limited to 5 rows):
+--+--+--+--+
| TO_CHAR(HU_TS) |
Hi All,
I came across a weird situation while running a query with group by.
I executed 2 queries:
1)
select trunc(hu_ts,'DAY',1),hu_ho_id,hu_stream_id,sum(hu_usage) from
se_dwh.homes_usage_hour where hu_ho_id in (4720,6854) group by
trunc(hu_ts,'DAY',1),hu_ho_id ,hu_stream_id;
| 2015-03-19