[MCOL-1265] Aggregtion through Events is not working Created: 2018-03-13  Updated: 2022-11-05  Resolved: 2022-11-05

Status: Closed
Project: MariaDB ColumnStore
Component/s: N/A
Affects Version/s: 1.1.2
Fix Version/s: Icebox

Type: Bug Priority: Minor
Reporter: BOBY PETER Assignee: Unassigned
Resolution: Won't Do Votes: 1
Labels: None
Environment:

REHL 7

getsoftwareinfo Tue Mar 13 13:42:25 2018

Name : mariadb-columnstore-platform
Version : 1.1.2
Release : 1
Architecture: x86_64
Install Date: Wed 29 Nov 2017 11:33:08 AM EST
Group : Applications/Databases
Size : 113942794
License : Copyright (c) 2016 MariaDB Corporation Ab., all rights reserved; redistributable under the terms of the GPL, see the file COPYING for details.
Signature : (none)
Source RPM : mariadb-columnstore-platform-1.1.2-1.src.rpm
Build Date : Thu 16 Nov 2017 10:20:27 AM EST
Build Host : ip-172-30-0-125.us-west-2.compute.internal
Relocations : (not relocatable)
Vendor : MariaDB Corporation Ab
URL : http://mariadb.org
Summary : MariaDB-Columnstore software


 Description   

I have a column store table with 600 columns which is populated every 15 min by some ETL process.

TBL: UUID, StartDate, Hour, Minute, << 600 columns >>

I created another table with same columns (without minute column) so that I could do hourly aggregation.

TBL: UUID, StartDate, Hour, << 600 columns >>

I created an event that does the aggregation (sum) from 15 min table to this hourly table. The information_schema.events says that it is triggered but there is no data in the hourly table.



 Comments   
Comment by David Thompson (Inactive) [ 2018-03-14 ]

Do you have a simplified example that reproduces the problem? Also did this ever work - i remember you filed an events related issue a while back and got it working (MCOL-1118), is this related or different?

Comment by BOBY PETER [ 2018-03-14 ]

This is different
If I insert just the date and hour column, into the table with 600+ columns, via event it works.

TBL: UUID, StartDate, Hour, << 600 columns >>

insert into TBL(StartDate,Hour) select cast(now() as date),hour(now()) – event scheduled to hourly

When I changed the same event, to insert from another columnstore (having many columns), it triggers but no data gets inserted.

Comment by patrice [ 2018-04-13 ]

I have a very similar issue, I cannot make an event work inserting data with 'insert into select' from a columnstore table into a columnstore table. The statement works fine outside of the event. It actually trigger the cpimport but 0 rows are added to the table.

Comment by Todd Stoffel (Inactive) [ 2022-11-05 ]

Item is out of date. Closing due to inactivity. If you feel this was done in error please open a new ticket.

Generated at Thu Feb 08 02:27:27 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.