When I ran this(https://thirdeye.readthedocs.io/en/latest/getting_started.html#step-3-create-the-tables-in-the-thirdeye-database), I got an error below.

ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'alias if not exists TO_UNIXTIME as $$ long unix_timestamp(java.sql.Timestamp tim' at line 1

@Shounak Kulkarni which version of MySQL server is suggested for this issue?

Hey @Luy, the required version is 5.7

Ok, I'm trying with V 5.7 now

If you are using https://github.com/yupeng9/incubator-pinot I’d rather recommend to use this one: https://github.com/cyrilou242/thirdeye-oss You can find a dockerized quickstart here: https://github.com/cyrilou242/thirdeye-oss/tree/master/quickstart You can then edit the data-sources file to connect to your Pinot instance

Yes, I'm using yupeng9/incubator-pinot repo now.

https://github.com/cyrilou242/thirdeye-oss Is it separated from Pinot independently?

Hi @Cyril de Catheu I could load Pinot dataset in ThirdEye based on your advice. I can see that dataset in thrideye-admin/Dataset page now, but can't load it in RCA or Anomaly Detection page. Now quick question, to configure a simple alert, what should I do? Configuring alert in Pinot or ThirdEye?

Awesome @Luy! Please read here to configure a simple alert: https://thirdeye.readthedocs.io/en/latest/basic_config.html https://thirdeye.readthedocs.io/en/latest/templates.html

Hi Team. I tried to test ThirdEye Pinot for real time data monitoring and anomaly detection, but it didn't work completely. So we decided to use StarTree cloud service for anomaly detection and alerting works. Could you help us to instantiate that service on the cloud? Eventually we need to set real-time data in CSV and JSON format and to define custom rules of anomaly detection, also subgrouping for alert notification, etc on our cloud server. Let me know what we need to do. Thanks.

@Cyril de Catheu Do you have any recommend for me?

Hey @Luy, sorry I missed the message above somehow. What is your current status with StarTree cloud? Let me put @Uday Vallamsetty and @Madhumita Mantri in the loop. You can discuss getting started with cloud with them. I think a call will help.

@Cyril de Catheu Thanks for your update. Don't mind my issues. Now I'd like to get ThirdEye-Pinot working on our Azure machine. Our company team will contact you when your team have time to help us. Let me know when we can talk in more detail. Thanks.

Hey, folks! I just posted in #CDRCA57FC about the new StarTree Community Slack workspace we’ve just launched.

Here’s a blog post with more details: https://www.startree.ai/blog/introducing-startree-community-slack

If you’re in this channel, you should for sure join the new workspace. We’ll be migrating discussion of ThirdEye over there, and eventually archiving this channel.

There’s already a #thirdeye channel in that workspace, so sign up and join it! I look forward to seeing you there. 🙂

<!channel> We recently launched Source Availability of StarTree ThirdEye along with StarTree Community Edition to get started for free. To get started: • (1) Submit this form to download StarTree Community Edition for free: https://get.startree.ai/startree-community-edition • (2) Watch the StarTree ThirdEye video to learn how to use it: • (3) Read the StarTree ThirdEye blog to learn about it more: https://www.startree.ai/blog/introducing-startree-thirdeye-anomaly-detection-and-insights-with-apache-pinot Please note: we will be archiving this sub-slack channel very soon! So, do not forget to join the StarTree Community slack channel (link: https://communityinviter.com/apps/startreedata/startree-community) for continued support from the community. cc: @Tim Berglund, @Kishore G

Hi Team How do we configure Pinot as a DataSource for ThirdEye? I have ThirdEye Server and Pinot running in a debugger. I have the ThirdEye UI running. When I attempt to create a pinot datasource, it fails in the DataSourcesLoader class.

public ThirdEyeDataSource loadDataSource(DataSourceDTO dataSource) {
  try {
    final String factoryName = dataSource.getType();
    checkArgument(dataSourceFactoryMap.containsKey(factoryName),
        "Data Source type not loaded: " + factoryName);

Issue is the dataSourceFactoryMap is empty. Looks like that is because the plugin was not loaded. What is the correct class or jar to place in the plugins directory?

Hi team, i want to setup a alert on a calculated measures using thirdeye. Like alert on revenue per click(RPC). So i created a custom template and get this worked. but now in RCA/investigation its still showing numbers of numerator only and not numerator/denominator in formula. Can you help.

ThirdEye

This is template which i created and used. Do you see, if i have missed something in this ?

Hi @Sanjay Aswani Assume you are using community edition. For community edition we have basic and vanilla features for RCA. If you are looking for custom experience in RCA then it is supported in Enterprise version. Looping in ThirdEye Eng to see if any other workaround might work. Cc : @Suvodeep Pyne and @Cyril de Catheu

Help Shape StarTree ThirdEye Community Edition: Your Feedback Needed! Hey Everyone, We need your insights to make StarTree ThirdEye Community Edition even better! Share your thoughts in our quick survey—it’ll only take 2~3 minutes. Your feedback is a gift! Submit your response to automatically enter into a draw to be one of the 3 fortunate winners to receive a $50 voucher to spend in our swag store. [Click here to start the "Survey"] What to expect? • Why you're exploring StarTree ThirdEye • Challenges you're tackling • Your first impressions • Any hurdles to full use • Your wish list for features Thanks for helping us evolve! Cheers, The StarTree ThirdEye Team cc: @Yarden Rokach

Gentle Reminder: Share Your Feedback on StarTree ThirdEye Community Edition! Hello, Just a friendly reminder that the StarTree ThirdEye Community Edition feedback survey is still open! We only have a few days left to collect valuable insights from our community, and your participation would be highly appreciated. Your feedback is a gift! Submit your response to automatically enter into a draw to be one of the 3 fortunate winners to receive a $50 voucher to spend in our swag store. Click here to start the survey: [Survey Link] Thanks again for your time and consideration. Sincerely, The StarTree ThirdEye Team and @Yarden Rokach

Gentle Reminder! Incase you missed it! Share Your Feedback on StarTree ThirdEye Community Edition Today! Hello, In case you missed it! A gentle reminder to participate in the StarTree ThirdEye Community Edition feedback survey! We're closing the survey at the end of next week, and we don't want you to miss your chance to shape the future of this valuable tool. Your feedback is crucial to ensure we're building the right features and functionalities for our users. The survey is anonymous and takes only less than 5 minutes to complete. Click here to start the survey: [Survey Link] We appreciate your time and look forward to hearing from you! Sincerely, The StarTree ThirdEye Team cc: @Yarden Rokach

[Attention - Needed Final Day!] Don't Miss Your Chance to Help Improve StarTree ThirdEye Community Edition! Hello, This is your very last chance to participate in the StarTree ThirdEye Community Edition feedback survey! The survey closes by Monday EOD (3/4), and we urge you to share your valuable insights before it's too late. Your feedback is critical for us to understand your needs and priorities, and it will help us guide the development of the platform in the right direction. The survey is anonymous and only takes about 10 minutes to complete. Click here to start the survey: [Survey Link] Thank you for your time and collaboration. We deeply appreciate your participation! Sincerely, The StarTree ThirdEye Team cc: @Yarden Rokach

[Attention - Needed Final Day!] Don't Miss Your Chance to Help Improve StarTree ThirdEye Community Edition! Hello, This is your very last chance to participate in the StarTree ThirdEye Community Edition feedback survey! The survey closes by Monday EOD (3/4), and we urge you to share your valuable insights before it's too late. Your feedback is critical for us to understand your needs and priorities, and it will help us guide the development of the platform in the right direction. The survey is anonymous and only takes about 10 minutes to complete. Click here to start the survey: [Survey Link] Thank you for your time and collaboration. We deeply appreciate your participation! Sincerely, The StarTree ThirdEye Team cc: @Yarden Rokach

Hi team, i am using thirdeye for generic alerting. I have a use case but not finding any way to make it run with thirdye. I want to generate alert if CPC of a campaign drops/ spikes by x%. But I want to run this for top 10 campaigns by CPC only and not all campaigns of system. In superset i can see this data as taking top 10 campaigns CPC sorted and adding those in filters in timeseries graph. Please can you help, how can we configure this alert in thirdeye. Thanks

Hi @Sanjay Aswani I can think of following option: 1. Pre-calculate Top Campaigns: Use Pinot to create a dimension filtering the top 10 campaigns by CPC (e.g., scheduled job or materialized view). 2. ThirdEye Alert with Filter: Configure a ThirdEye alert to trigger only when the "Top 10 CPC Campaigns" dimension is active and the CPC drops/spikes by your threshold (using reference window for comparison). Another option not sure if it is supported in the community edition: You can modify the alert template and update the data fetcher to see if you can modify Pinot SQL to include top compaigns. https://dev.startree.ai/docs/get-started-with-thirdeye/alert-configuration#datafetcher