108 questions
0
votes
0
answers
24
views
Error: "stream load Times: Reason: Unable to display. src line [Unable to display]"
When I load data from local file to doris table, I get the error:
Reason: Unable to display. src line [Unable to display]
What happened?
My version of Apache Doris is 2.1.5, and the steps to ...
- 78
0
votes
0
answers
21
views
When using Broker Load with Kerberos configured and encountering the error 'Cannot locate default realm'
My error is from broker load then I load data from S3 to apache doris. The broker load is with Kerberos configured, and I have already configured the Kerberos in my doris, too.
The useful info is ...
- 78
2
votes
1
answer
63
views
Hive Catalog 'show tables' works fine but querying errors: "java.net.UnknownHostException: xxxxx"
After I created a Hive catalog, show tables works fine, but querying errors:
java.net.UnknownHostException: xxxxx
The steps to reproduce are:
Create a Hive catalog (Hive is on HDFS):
CREATE CATALOG ...
- 78
4
votes
1
answer
147
views
Restriction of traversal through specific aisles to "enter-exit from same side" in a pathfinding graph?
I'm working on a warehouse layout in Python where a route is calculated between multiple pick locations. The layout includes both wide and 'ultra-narrow' aisles. In the real-world setup, ultra-narrow ...
- 41
1
vote
1
answer
194
views
How to include count column with filter to calculate percentage out of a total where total has different filters in Snowflake?
In warehouse database, there are multiple waves. Each wave has a certain number cartons that needs to be pulled from storage and delivered to the designated area where the items in that carton gets ...
- 31
0
votes
1
answer
461
views
Snowflake - Warehouse Node Utilization data?
I vaguely recalling someone stating that there is at least an "estimated" node usage of a Warehouse in Snowflake.
Not a cluster. The nodes of a cluster. For instance a Large Warehouse in ...
- 983
0
votes
2
answers
179
views
How can I assign a value to warehouse_id through a custom module in Odoo?
I'm using Odoo 14 community version to test some developments locally.
I want to create a custom module that assigns a specific warehouse when the Sale Order is created depending on a logical ...
- 35
0
votes
1
answer
37
views
Optimizing Subquery Performance for Calculating Aggregated Weight Column in MySQL
I have a SQL query with a subquery that calculates the aggregated weight based on certain conditions. However, I'm experiencing performance issues with this subquery, and I would like to optimize it ...
- 1
-1
votes
1
answer
374
views
Acumatica Scan Move
I am trying to add an additional step when using the set qty button in Scan Move screen (AM302010). I would like to set a value to another field before the standard functionality that sets the qty ...
0
votes
1
answer
72
views
How to find IP address to connect in AWS data warehouse
I need to connect data warehouse on AWS but the administrator asked me this:
"IP address that you're going to connect to the data warehouse from?"
Which IP he is referring to, is it my ...
0
votes
2
answers
478
views
How can I use the warehouse?
I have done the following steps:
Creating a warehouse (settings)
Creating a database
Creating a stage
Creating a file_format
Loading data into database through stage in worksheet
Doing different ...
- 3
0
votes
1
answer
106
views
Is single table with multiple updates better than multiple tables inserted at different times in Redshift
I have a task fact table with following columns
Task ID (BIGINT)
User ID (BIGINT)
Created Timestamp (TIMESTAMP)
First assigned Timestamp (TIMESTAMP)
First assigned time taken (BIGINT)
First comment ...
- 1,162
1
vote
2
answers
7k
views
Why I'm getting '000606 (57P03): No active warehouse selected in the current session. Select an active warehouse with the 'use warehouse' command.'
I'm getting the following error when doing a 'dbt run'
000606 (57P03): No active warehouse selected in the current session. Select an active warehouse with the 'use warehouse' command.
My profile has ...
- 11
2
votes
0
answers
254
views
how are Updates and Deletes handled in both Data Warehouses and Data Lakes?
I'm trying to understand how Update and Delete functions are performed in Data Warehouses, Lakes and Lakehouses.
Databricks argues that they can perform upserts easily, which I would understand as ...
- 163
0
votes
0
answers
280
views
Standard techniques for calling external APIs on data warehouse data
What are the standard ways in which data from a data warehouse can be used to query an external API and then write back to the table in the warehouse?
With a normal database + backend server, it can ...
- 5,201
1
vote
1
answer
237
views
Accessing special storage in storage system Anylogic
I need to access a specific storage within a storage system (which is basically a list like this storageSystem= {storage1, storage2, storage3} in Anylogic.
I tried this, but it does not work:
...
- 11
0
votes
2
answers
354
views
Storage system in Anylogic
How can I model a "flow through" storage rack in Anylogic? Meaning that the pallets will be stored from one end and be retrieved from the opposite end.
How can I model that the shelves in ...
- 11
1
vote
0
answers
102
views
sql query issue: warehouse aging inventory when negative entries
I found a warehouse aging inventory example online (see modified code below).
Everything works fine if the entry type for purchase (0) is positive and for sales (1) is negative. But if the values are ...
- 21
0
votes
1
answer
178
views
Apache Kylin stuck on 'Convert Cuboid Data to HFile'
I installed the following stack on my lab setup:
Hadoop 2.7.1
Hive 1.2.2
HBase 1.7.1
Kylin 3.1.2
I now try to build a cube from the sample dataset provided by Kylin itself, and the process gets ...
- 238
0
votes
1
answer
116
views
T-SQL, Warehouse principle, two datasets combine to one dataset using FIFO
I would like to combine data between two datasets using FIFO. I think the warehouse principle is a good example to explain what I need.
BUY table:
ID_BUY
Date
Item
Count
39
2022-01-01 00:00
Pencil
...
- 25
0
votes
1
answer
135
views
How to use the OWB repository assistant using command line
We need to migrate our OWB repository to a new one running on 11.2. This will eventually be converted to ODI but as a 1st step we need to do this migration.
I've been following the notes in
https://...
- 17
0
votes
2
answers
5k
views
MySQL - COUNT for rows with the same name
I want to count how many entries with the same name from my table device [device.name] have the value 2 as warehouse [device.warehouse_id].
So for example I have 5 rows, 2 with name = Beam, 2 with ...
0
votes
1
answer
669
views
Override method not being called from warehouse mobile application ax
I have been working on some requirement for advance warehouse mobile application in AX. The requirement was to do something when item is scanned. So in order to perform this I have ...
- 361
0
votes
1
answer
43
views
Data Warehouse error related to a group by mistake
So I have 2 tables:Clients_Test and Vacations_Test.I need to create a warehouse that has 2 dimensions:
d1_month and d2_destination.The main table that shoud contain the fields of these 2 dimensions is ...
- 5
0
votes
1
answer
360
views
How to create orders for picking process at warehouse operations using Anylogic
During the creation of a generalized warehouse model, I ran into a problem when trying to create an order event that can be used by order pickers to retrieve the products from the storages racks. ...
- 1