Stack Overflow
Stack Overflow

Questions tagged [kinetica]

For developer questions related to Kinetica Active Analytics Platform, a commercial GPU-accelerated SQL analytics database platform developed by Kinetica DB Inc.

Kinetica is a scalable cloud database for real-time analysis on large and streaming datasets using SQL. Kinetica harnesses modern vectorized processors and is orders of magnitude faster and more efficient for real-time spatial and temporal workloads. Kinetica's lockless, distributed architecture coupled with vectorized queries allows it to ingest data at really high speeds and perform truly real-time analysis on fresh data.

Documentation: https://www.kinetica.com/docs/

Website: https://www.kinetica.com/

14 questions
5
votes
1 answer

Kubernetes deployment not auto-terminating after successful run of command

I have a Kubernetes cluster in which I've created a deployment to run a pod. Unfortunately after running it the pod does not want to self-terminate, instead it enters a continuous state of restart/CrashLoopBackOff cycle. The command (on the entry…
jpjenk
  • 459
  • 2
  • 8
  • 14
3
votes
1 answer

I am having trouble designing a REST api call using requests to hit a Kinetica DB instance to confirm it is working

Here is the code I tried: import requests test = requests.request("GET",'https://mycoolurl.host/admin/verifydb') print(test.json()) It results in a 400 error.
james-see
  • 12,210
  • 6
  • 40
  • 47
2
votes
1 answer

I am having problems authenticating with Kinetica's endpoint using the username and password for the REST endpoint

Passing in username and password in the headers does not appear to work. Neither does wrapping it in json. I am getting a 500 not authorized error.
james-see
  • 12,210
  • 6
  • 40
  • 47
2
votes
0 answers

Apache Spark: Running jobs in parallel in standalone mode

We are trying to get data from an Oracle database into Kinetica database through Apache Spark. We installed Spark in standalone mode. We executed the following commands. However, we have tried everything but we couldnt manage to run jobs in…
O.Ekinci
  • 21
  • 2
2
votes
1 answer

How to fetch records from gpudb(kinetica) tables using command line interface

I am trying to connect to gpudb tables but getting below exception. The command which i used to connect to gpudb tables is: python gpudb_cmd.py --gpudb < ip >:< port > --username < username > --ask-password --query 'select * from…
Shubham Shah
  • 99
  • 1
  • 1
  • 7
1
vote
1 answer

How do I apply nvprof to Kinetica?

Can someone pls gimme a hint on how to apply nvprof to Kinetica ? 1) I see the name of processes of Kinetica which sits upon GPUs is gpudb_cluster_cuda, and its parent process is gpudb_host_manager. I find gpudb_host_manager is started by…
nasica88
  • 1,185
  • 10
  • 10
1
vote
0 answers

How are SQL Server-based processing features different than Kinetica db?

I'm moving into a data-intensive financial project where I will be leveraging GPU processing for performing simulations. However I'm curious about some new database technologies such as www.kinetica.com which tout GPU-based processing. However SQL…
ElHaix
  • 12,846
  • 27
  • 115
  • 203
0
votes
1 answer

How to Set Log Level for Third Party Jar in Spark

I use Spark to write data from Hive Table to Kinetica using this jar: kinetica-spark-7.0.6.1-jar-with-dependencies.jar. However, when I run spark-submit, the logger from the jar is printing the JDBC connection string with its credentials as…
Ghifari Dwiki Ramadhan
  • 30
  • 7
0
votes
1 answer

What is the proper update syntax for Kinetica?

I'm using Kinetica 7.0.20.3, I need to update field F1 from table A using field F2 from table B, table A and B both can join on the key column, I tried update statement below, but didn't work. update Table1 A, Table2 B set A.F1 = B.F2 where A.pk =…
jackodev
  • 5
  • 1
0
votes
1 answer

Kinetica Heatmap Not Displaying on Some Map Sizes

I have a table with some geospatial data that I'm displaying on a heatmap in OpenLayers. It is working great on most screens, but on my ultra-wide monitor, when I full-screen my browser window, it disappears. I have other layers that are showing on…
jackodev
  • 5
  • 1
0
votes
1 answer

Kinetica Multi-head Lookup

I'm currently evaluating Kinetica DB for an analytics project on a 3 node cluster to build a custom dashboard on top of it. As far as I understand, there is a way retrieving the records from the data nodes directly, which is called "multi-head…
LinusDev
  • 1
0
votes
1 answer

How to change domain / ip address of a Kinetica GPUDB Kagent and Gadmin instance after it is deployed?

I have a fresh Kinetica deployment that was super easy via Kagent GUI on a new VM. The domain I used is no longer available, so I wanted to change it back to a local ip address. I was able to change the domain to an ip address in gpudb.conf under…
james-see
  • 12,210
  • 6
  • 40
  • 47
-1
votes
1 answer

How does Kinetica's backup/restore facility work in Kinetica KAgent?

What exactly happens under the cover? Does it create a new complete snap shot of the full data set each time? Is there some type of differential comparison with the last snapshot? What is the state of the system during the backup?
Esther_DBA
  • 1
-2
votes
1 answer

SQL: Join Table A With Table B [( a.Col1 = b.Col1 && a.Col2 = b.Col2) and max(transacrionTime)]

I need help, in building SQL (Query or CTE) for below scenario Problem : I need to join my Master Table A with detail Table B to find out matching record/row(for each record of TableA) from Table B having same itemType, country having…
Ashz
  • 23
  • 5