Hi everyone, I have a simple requirement to get the result from two hive tables(lying under trino) individually and join them to display the experiment.
any procedure or hierarchy of steps to follow for the same.
Prerequisites done : Trino setup as a data source is added.
07/19/2023, 9:13 AM
can you join between them?
there are a few ways to make this work, but the easiest is probably to use joins or unions on the assignment query.
07/19/2023, 10:32 AM
yes we can join., we have a condition to join the two tables.
is there any hierarchy to follow.
when I say hierarchy, I created a data source.
To run an experiment , I need to fetch the data out of data source(column and structure we need). Then on the basis of results , joined data out of the two tables, then do grouping between some random columns on the fly and see the graphical representation of stats.
@fresh-football-47124 any inputs?
07/20/2023, 10:08 PM
I’m not sure exactly what you’re trying to do. You can do the unions or joins in either the assignment query or in the metric query (or both)