Stack Overflow
Stack Overflow

Questions tagged [kognitio]

The Kognitio Analytical Platform is an in-memory, Massively Parallel Processing (MPP) relational database management system (RDBMS) that is optimized for analytical workloads.

Kognitio allows you to gain better business insight with the following advantages:

Ease of use – Load, explore and analyse your data fast with fast data scan rates

Flexibility – Run on any industry standard hardware, there is no need to invest in a proprietary hardware solution

In-memory analytics – Through intelligent usage of RAM and disk, Kognitio offers unprecedented speeds to access and query complex data

Linear scalability – As data volumes increase, query performance remains constant from one to thousands of nodes. For example, querying 5TB on a 100-node system will take the same time as querying 50TB on a 1000-node system. Also, Kognitio can be reconfigured in size to help respond to the requirements of a data analytics project

Ultra-high performance – Get fast results. Tests have shown Kognitio to out-perform other database / data warehouse solutions by up to sixty times

Lower total cost of ownership – System performance eliminates the need for the proliferation of data marts

Analytics in real-time – Kognitio enables complex analytics on terabytes of data in seconds by using in-memory, Massively Parallel Processing technology

Flexible licensing model – Kognitio can be licensed on a “right-size-at-the-right-time” model for cost-effective data analytics that meet the demands of a changing project, or even changing geography

Increased disk performance – Kognitio offers even faster throughput speeds with increased performance in both disk speeds and capacity

15 questions
1
vote
2 answers

Different type of imaging techniques in kognitio

Can anyone please explain me what are all the imaging techniques available in kognitio. Would be great if you cover the below techniques. 1) Replicated 2) REPLICATED PARTITION IMAGE BY (column_name) 3) HASHED ON (column_name) PARTITION IMAGE BY…
Madhankkumar S A
  • 47
  • 7
1
vote
3 answers

CASE statement when using LEFT JOIN

I need some help in fixing a data aberration. I create a view based on two tables with Left Join and the result has some duplicates (as given in the logic section) Data Setup: ******************* TEST1 ******************* PRODUCT VALUE1 …
Srini V
  • 11,045
  • 14
  • 66
  • 89
0
votes
0 answers

Failed to run slider after kognitio cluster creation

I am trying to integrate kognitio with kerberized cluster. While creating kognitio cluster I am getting below error: Starting slider cluster for test1 Failed to run slider command /home/kognitio/kodoop/slider/bin/slider start kognitio-test1 I…
Ashish Mathur
  • 33
  • 4
0
votes
0 answers

SQL sampling Natural key vs Surrogate key

I have a table with the natural key with VARCHAR datatype. The incoming feed could be a VARCHAR or BIGINT natural key but stored as VARCHAR datatype. We generate the surrogate keys using the natural keys. The incoming daily feed has gaps and islands…
Srini V
  • 11,045
  • 14
  • 66
  • 89
0
votes
1 answer

How to efficiently write keying logic for full range of BIGINT

I have a column flowing in with the full range of integers. Whilst generating keys on the INT column, I need to push the 0's and negatives down (ordered DESC) and the positive keys to stay at the top (ordered ASC/DESC). I came up with two approaches…
Srini V
  • 11,045
  • 14
  • 66
  • 89
0
votes
3 answers

concatenate and de-dupe multiple rows

I have some incoming rows in the below format. | Col1 | Col2 | Col3 | | 1 | A | 1 | | 1 | A | 1,2 | | 1 | A | 1,3 | | 1 | A | 2,4 | Desired outputsql is | Col1 | Col2 | Col3 | | 1 | A | 1,2,3,4 | Basically,…
Srini V
  • 11,045
  • 14
  • 66
  • 89
0
votes
2 answers

Order by (parent, child group) and values alphabetically

Found an interesting problem here. ResultID ParentID ValueX -------------------------- 1 0 GrandParent 2 1 Parent1 3 1 Parent2 4 2 Child1 5 2 Child2 6 3 …
Srini V
  • 11,045
  • 14
  • 66
  • 89
0
votes
1 answer

How to find resource intensive and time consuming queries in WX2?

Is there a way to find the resource intensive and time consuming queries in WX2? I tried to check SYS.IPE_COMMAND and SYS.IPE_TRANSACTION tables but of no help.
Srini V
  • 11,045
  • 14
  • 66
  • 89
0
votes
1 answer

How to change the Queue Id in WX2?

Following is the current records from the QUEUES. SELECT * FROM SYS.IPE_ALLQUEUES; ID NAME ------- ---------- 100004 NAGIOS 1 DEFAULT 100003 OTHER 100002 APP 100001 ANALYST 0 NONQUEUED ID column is currently defined as INTEGER…
Srini V
  • 11,045
  • 14
  • 66
  • 89
0
votes
1 answer

how to connect kognitio database from mysql

I need to select some data from WX2 Database and put it in MYSQL DB. Can any one help me on this? Is ODBC.ini configuration will work for the mysql database to connect to WX2 database? Thanks
user3453044
  • 13
  • 5
0
votes
1 answer

Key and value lookup in relational database

I have the data as follows TABLE1 ------ A |B 1 |2 3 |4 TABLE2 ------ C |D 1 |11 2 |12 3 |13 4 |14 The expected output is D , D -------- 11, 12 13, 14 The logic behind this output is, I need to create a view so that the view always…
Srini V
  • 11,045
  • 14
  • 66
  • 89
0
votes
1 answer

Escape double quote Character in Kognitio

It seems that the Kognito console use this template for password reset (also create user) ALTER USER user_name ALTER PASSWORD TO " "; -- we cannot include a " character in the password which would end up in syntax error. How do we escape…
Srini V
  • 11,045
  • 14
  • 66
  • 89
0
votes
1 answer

Efficiently copying Kognitio tables between two environments

I want to copy a table from one environment to another. I know I could export it from environment one, then transfer the resulting file to the second environment, then use import to load it, but is there an easier way? In particular, is there a way…
Srini V
  • 11,045
  • 14
  • 66
  • 89
-1
votes
1 answer

External Scripting and R (Kognitio)

I have created the R script environment (used this command to create it "create script environment RSCRIPT command '/usr/local/R/bin/Rscript --vanilla --slave'") and tried running the one R script but it fails with the below error message. ERROR:…
Madhankkumar S A
  • 47
  • 7
-1
votes
1 answer

Issue in creating image for a simple view

DB is really fast .. But one particular simple view is getting hung when I try to create the image for it. Have tried creating images for complex views and got succeeded. Any specific reasons ?
Madhankkumar S A
  • 47
  • 7