Questions tagged [wx2]

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

13 questions
1
vote
1 answer

SQL replacement for Recursive CTE

I have a table Test which contains TEST ---- tablename|columnvalue|rankofcolumn A|C1|1 A|C2|2 A|C3|3 A|C4|4 B|CX1|1 B|CX2|2 C|CY1|1 C|CY2|2 C|CY3|3 I want to generate the path along with other columns as…
Srini V
  • 11,045
  • 14
  • 66
  • 89
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
1 answer

Unable to connect to Kognitio via Pentaho - Cannot create socket for IP Error

My laptop is on Java SE 8 Update 121. I am running on Pentaho V7.0 "data-integration/lib" contains Kognitio.jar (678 KB) Below is the error message Error connecting to database [sdf] :org.pentaho.di.core.exception.KettleDatabaseException: Error…
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
1 answer

How to manipulate concatenated columns in SQL

Say I have the below dataset WITH dataset (hno,sorder,level,dummy,maxorder) AS ( SELECT 1, 1, 'val1', 'NULL1', 5 FROM dual UNION ALL SELECT 1, 2, 'val2', 'NULL2', 5 FROM dual UNION ALL SELECT 1, 3, 'val3', 'NULL3', 5 FROM dual UNION…
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

External script (R) not working

When I try to run the external script (R Script) from kognitio console. I'm getting the below error message. Error:external script vfork child: No such file or directory Can someone please help me to understand what it is!
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:…