Skip to content

Tag: sql

Optimizing Access Query with Multiple sub-queries

I have a table of data that contains baseline project information, called ADMIN_WORK. I have a separate table that contains various attributes related to each project listed in ADMIN_WORK called WR_ATTRIBUTE. The structure of WR_ATTRIBUTE is such that each project has about 300 attributes (300 rows in the tab…

My script has no effects in more than 3 rows

The script works fine when it has 2 rows. Stop reading from 3. This is MSSQL Server 2005. Try anyway without any result. There is no error message. But if I have more than 10 rows, it doesn’t affect the row that should affect. Answer Given the new information in your comment you should simplify this to …

SQL select based on column value

We have a DB table that contains company job codes like so: The ‘***’ in company represents an enterprise level job code which can be overwritten at the employer level (DEU, DEC). I need a select statement that returns rows with the following conditions: If there are no company specific Codes (e.g…

PutHiveQL NiFi Processor extremely slow – misconfiguration?

I am currently setting up a simple NiFi flow that reads from a RDBMS source and writes to a Hive sink. The flow works as expected until the PuHiveSql processor, which is running extremely slow. It inserts one record every minute approximately. Currently is setup as a standalone instance running on one node. T…

Fetch page data of specific OR other language

I have a table with webpage data that looks somewhat like this: row_id ⁞ page_id ⁞ lang ⁞ title ⁞ slug ────────┼─────────┼──────┼────────────────────┼──────────────── 1 ⁞1 ⁞……