sorry for the amateur question. But does anyone kn...
# general
j
sorry for the amateur question. But does anyone know how to join os_version table to rpm_packages table? i cant seem to find a common identifier to perform the join. Thanks!
t
You can compose these tables with
select * from rpm_packages, os_version
😮 1
s
What does joining them mean? If there’s no common identifier, than the join is somewhat odd?
j
to create a single table. But thanks! it works!
s
What does “single table” mean? Sort of where I’m going here, is while you can stitch arbitrary data together, it may lose semantic meaning.
j
ideally i want to stitch os_version, rpm_packages and system_info together. so that for each application found in rpm_packages i know the hostname as well as the os that it is running on
s
Depending on exactly what you’re doing, there may be other routes. Sometimes people use decorators for this, depends a lot on what the resultant data storage is like.