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.
f
fresh-football-47124
07/19/2023, 9:13 AM
can you join between them?
fresh-football-47124
07/19/2023, 9:14 AM
there are a few ways to make this work, but the easiest is probably to use joins or unions on the assignment query.
q
quiet-answer-57776
07/19/2023, 10:32 AM
yes we can join., we have a condition to join the two tables.
quiet-answer-57776
07/19/2023, 10:40 AM
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.
quiet-answer-57776
07/20/2023, 5:27 AM
@fresh-football-47124 any inputs?
f
fresh-football-47124
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)