Stack Overflow
Stack Overflow

Questions tagged [sap-iq]

SAP IQ (formerly Sybase IQ) is a column-based RDBMS used for business intelligence, data warehousing, and data marts. Produced by Sybase, an SAP company, its primary function is to analyze large amounts of data in a low-cost, high-availability environment.

287 questions
1
vote
1 answer

Syntax error when selecting column 'Comment' in Sybase IQ

I have a table A with some columns in Sybase IQ. One of the columns is named "Comment". Whenever I select that column: select Comment from A I got the error: [Error Code: 102, SQL State: 42W04] SQL Anywhere Error -131: Syntax error near…
hydradon
  • 1,316
  • 1
  • 21
  • 52
1
vote
0 answers

HDP to SAP Sybase IQ ETL

If I have ingest data from Hortonworks data platform to SAP Sybase IQ and vice versa, which is the best ETL tool suited for this scenario ? Can SAP data services support this functionality?
Saravana S
  • 83
  • 1
  • 4
1
vote
2 answers

Sqoop Import - Query must contain '$CONDITIONS' in where clause

sqoop import --connect 'jdbc:sybase:Tds:10.100.*.***:5500/DATABASE=****' --driver 'com.sybase.jdbc3.jdbc.SybDriver' --username "keswara" --password "****" --target-dir "/user/keswara/WT_CONSUMERSTATS" --verbose --query "select c.YEARMONTH as…
karthee
  • 49
  • 2
  • 14
1
vote
1 answer

Sqoop import from SybaseIQ to Hive - java.io.IOException: SQLException in nextKeyValue

When I am trying to import a table to Hive, I am getting a strange error. Query: sqoop import --connect 'jdbc:sybase:Tds:10.100.*.***:5500/DATABASE=****' --driver 'com.sybase.jdbc3.jdbc.SybDriver' --username "****" --password "***" --table…
karthee
  • 49
  • 2
  • 14
1
vote
2 answers

Possible "limit n/select top n" limitation within subquery workaround

I have the following case (the example I am demonstrating is on a dummy domain because for NDA reasons etc.). I have access to a production DB holding student data in the following shape: Student_ID Course_Name Total_Average_Grade 1 Maths…
rpd
  • 462
  • 1
  • 9
  • 24
1
vote
1 answer

Could not find function in dynamic library 'libudfex.so'

Accroding to IQ' udf guide, create udf procedure as below: Declare the UDF to the server by using the CREATE FUNCTION or CREATE AGGREGATE FUNCTION Write the UDF library identification function Define the UDF as a set of C or C++…
Jim
  • 25
  • 5
1
vote
1 answer

LOAD TABLE statement with NULLable dates

I m looking to do a batch load into a table, called temp_data, where some of the columns are NULLable dates. Here is what I have till now: LOAD TABLE some.temp_data (SomeIntegerColumn ',', SomeDateColumn DATE('YYYYMMDD') NULL('NULL'), FILLER(1),…
user2624034
  • 77
  • 1
  • 6
1
vote
2 answers

Sybase IQ - Splitting comma separated values in a column into rows

I see other solutions on here regarding splitting data values into rows but so far none of them work on Sybase IQ - either because it's not supported or I don't have the proper access to create procedures. I can do this very easily in Java but…
cpd1
  • 777
  • 11
  • 31
1
vote
0 answers

NOT IN is not working in sybase?

I have two table lets say Table1 and Table2 and both table have a column Name and ID I want to fetch all the name from Table2 which is not in Table1 I have written below query : Select Name,ID FROM Table2 t2 WHERE t2.Name NOT IN (Select t1.Name FROM…
user3717431
  • 103
  • 2
  • 9
1
vote
1 answer

Capping Running Total

I have a field A and would want to calculate field B as follows: B is a running total of A. Every time the running total goes over 900, B should restart its running total from 0 in the next row, as shown: A B 37 37 427 464 17101 …
SouravD
  • 127
  • 1
  • 12
1
vote
2 answers

sqoop export from hive/hdfs to sybase IQ database

I am trying to export data from HDFS/HIVE to SYBASE IQ database, I have tried with almost all the tags possible to implement into my command and created temporary table with just 1 column. Please find the command line below which I am using to…
Sameer Bhand
  • 43
  • 1
  • 9
1
vote
1 answer

@SqlQuery throws org.skife.jdbi.v2.exceptions.UnableToExecuteStatementException: java.sql.SQLException: SQL Anywhere Error -131

When I execute : @SqlQuery("select A.field1, A.field2, C.field3, C.field4, C.field5 from " + "table1 A, table2 B, table3 C WHERE A.field2 >= '1500' AND A.field2 < '9500' " + "AND A.field1 NOT IN (SELECT field1 FROM table4) AND A.field1 =…
Harbinger
  • 762
  • 2
  • 14
  • 36
1
vote
0 answers

Sybase datediff produces "data conversion not possible" error

I am trying to calculate age as of a given YYYYMMDD date (2013-12-13) using an unsigned integer YYYYMMDD date of birth variable (dob) from a Sybase IQ 15.4 database (setdata). It isn't my database and I have no control over how the data are stored.…
SarainVA
  • 11
  • 1
  • 3
1
vote
2 answers

Performance issue on using scalar UDFs , SQL, sybase iq

I've a performance issue with using Scalar User Defined Functions(UDF) in queries. There is a UDF fn_get(i int) which returns a scalar.. It holds lot of logic and performs normal scalar operations.. Actually SELECT *,fn_get(i) FROM #temp1; is…
rudebutgood
  • 43
  • 1
  • 6
1
vote
1 answer

Bulk load to HDFS from sybase database

I need to load data from sybase(production database) to HDFS. By using sqoop it is taking very long time and frequently hit the production database. So, I am thinking to create data files from sybase dump and after that copy the data files to hdfs.…
user1321939
  • 319
  • 2
  • 6
  • 18
1 2 3
…
19 20