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.
5 Likes

@Venkat_Krishnamurthy 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?

2 Likes

Hi @kcpevey,

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.

1 Like

Hi @kcpevey, for most installations as Candido points out, the connection port is set up in omnisci.conf (6274) - for the Mac preview, it is 16274

1 Like

I really enjoy it, but the Custom SQL metric doesn’t give any results. The same query works in the SQL Editor.

Hi @kautmaud,

can you post a Screenshot and possibly the Custom SQL you are using?

Sure! A simple division. It works in the SQL Editor.

And the error:

Hi @kautmaud,

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?

2 Likes

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:

Best Regards