OmniSci for Mac Preview
Hello OmniSci community!
Please post your questions here on the OmniSci for Mac Preview! We look forward to your feedback and suggestions. A couple of points to note
- This is an experimental build, so will likely have a few rough edges. Crashes, bugs, unexplained slowness all should be rare, but can happen. If you run into an issue, please be as detailed as possible - what were you trying to do, the query itself (logs and/or screenshots will help!)
- This is not a supported product(and has no guarantees or warranty associated with it), but we will do our best to respond to relevant questions in a timely manner.
@anon23740792 thanks for this great product! I was able to get up and running in a snap and view the dashboards immediately. One question - I'd like to access the database programmatically. Where can I find the connection information to the database that's now running on my machine?
10x for joining our community.
To connect to the database the standard posrts are 6274 for binary connectio and 6278 for http connection; so basically you have to connect to the host name where omnisci is installed (or localhost if you are calling from the same machine) on port 6274.
You are getting that error because you are not using an aggregate function on the custom meause; so if you need to sum your measure you should explictly use SUM(cost_eur/impr), AVG(cost_eur/impr) for averages,MIN,MAX and so on.
Normally those function are applied automatically by Immerse on your input, but in this case you are overiding that mechanism, so you have to write by yourself; if needed,you can also mix aggregates functions as an example SUM(cost_eur)/MIN(impr), use other functions like CASE e.g. SUM(CASE when country_code in('IT','FR',DE') then cost_eur*1.05 else cost_eur/impr end).
If you need more in dept guidance to use such expression feel free to ask in the forum
Thank you! Now I just need to know when I can purchase this product :smile:
I would also like to see support for more file types. Parquet would be very good since we have a few terabytes of parquet data and converting to json/csv is not the best solution.
I would also like to know the technical details. Are you leveraging the Apple Metal toolkit?
I am happy seeing people enthusiast, almost like me, about Immerse+OmnisciDB :partying_face:
Unluckily I haven't a machine with macOS installed, so I'm not 100% sure if Parquet files are supported on that platform, but you can try placing a Parquet file into your MA and load data into a table with COPY FROM command; you can run from SQL Editor of Immerse.
The syntax would be
COPY table_name FROM '/the_path_where_you_placed_the_file/parquet_file_name' WITH (parquet='true');
looking at DOCS, there are some limitations:
Import data in Parquet format. Parquet files can be compressed using Snappy. Other archives such as .gz or .zip must be unarchived before you import the data.
And the table should exist before the load starts.
As I said before, I'm not sure it's going to work, but it's worth a try :crossed_fingers:
Maps gone wild! Hello my former Omnisciers I just installed the new build, added a chart then tried to resize the map, upon doing so the map was showing beyond the bounds of the chart widget making it impossible to grab any other chart widget. Trying to resize to get it work only made it worse.
Please sign in to leave a comment.