Stack Overflow
Stack Overflow

Questions tagged [federated-table]

43 questions
0
votes
1 answer

how to create a remote mysql table by federate?

I have read this federate TABLE and now I would like to know what to do if I want to create the test_table (see this example in the link) from remote? As I do understand that test_table must be created on the federate server before. But I would like…
Walter Schrabmair
  • 1,251
  • 2
  • 13
  • 26
0
votes
0 answers

How can we handle null values for Data type INTEGER while using Federated/External tables for Google Bigquery?

While Using below query ,i am getting the error . bq mk --use_legacy_sql=false --nullmarker="\N" --external_table_definition=/tmp/bqschema dataflowjson.TEST1 FATAL Flags parsing error: Unknown command line flag 'nullmarker' Run 'bq help' to get…
DataVishesh
  • 197
  • 1
  • 5
0
votes
1 answer

BigQuery could not parse "\N" as INT or DATETIME using nullMarker: "\N" in table definition for external federated table

I am using \N for null either for INTEGER or DATETIME data types in the JSON table definition(nullMarker:"\N") for external tables but then also BigQuery is not able to parse it and throwing the below error: error message: Could not parse '\N' as…
flametech
  • 21
  • 4
0
votes
0 answers

How to use Federated Engine(Mysql) to Postgresql Table Migration

I tried using migrate mysql to postgresql. It Exist error for Below Message. Erro Message: 11:05:39 SELECT * FROM fed_orders LIMIT 0, 1000 Error Code: 1159. Got timeout reading communication packets 30.051 sec. Steps Used: a) Activate Federated…
Kalidoss KN
  • 41
  • 1
  • 9
0
votes
2 answers

'Error on remote system: 0 'when using FederatedX on MariaDB

I am using MariaDB 10.1 64x and experiencing error with FederatedX engine. First, I create an server: CREATE SERVER AAA_fed Foreign data Wrapper mysql_1 OPTIONS ( User 'user1', password 'password', host 'x.x.x.x', Port 3306, …
Trung Dao
  • 50
  • 1
  • 6
0
votes
1 answer

MySQL federated host "my ip" is not allowed to connect mysql server

I've confused about this problem, and still stuck out of it for a week. I've trying to federated table in mysql, but when tried to do query select to remote table. I got this message Error Code: 1429. Unable to connect to foreign data source: Host…
Bryan Andi Gerrardo
  • 17
  • 1
  • 6
0
votes
1 answer

uses of federated table doesn't work

I wanted to create a federated table so I have the following statement: CREATE TABLE `ldap` ( `Key_Id` varchar(35) DEFAULT NULL, `distinguishedName` varchar(250) DEFAULT NULL, `name` varchar(50) DEFAULT NULL, `givenName` varchar(50) DEFAULT…
Bigjo
  • 613
  • 2
  • 10
  • 32
0
votes
1 answer

MySQL Federated table crashes MySQL workbench

I just enabled Federated engine on MySQL 5.5 server. I set up a federated table on another server and made sure I had an IP passthrough setup on the server I'm connecting to on MySQL port. The connection is really slow. In MySQL workbench, initially…
user2187420
  • 39
  • 3
0
votes
1 answer

Store remote server credentials when using MySQL federated tables in a centralized and secure way

I would like to use MySQL federated tables as described in the documentation: https://dev.mysql.com/doc/refman/5.0/en/federated-use.html However, I would not like to have to repeat the remote server credentials with the password in the clear for…
xpereta
  • 692
  • 9
  • 21
0
votes
2 answers

Creating an Azure SQL federation sharded off last digit of INT/LONGINT?

Let say a table has a primary key (CustId) of type int or longint. We would like to shard this table into a federated table depending on whether the OrderId is odd or even. i.e. Federated 'primary key' = (Fed_key, CustId) where OrderId is of type…
DeepSpace101
  • 13,110
  • 9
  • 77
  • 127
0
votes
1 answer

Port SQL Server table to SQL Azure Federation

CREATE TABLE MyTable ( ID uniqueidentifier NOT NULL PRIMARY KEY Column1 nvarchar(256) NOT NULL UNIQUE, Column2 nvarchar(256) NOT NULL UNIQUE, ) How could I port the following table to SQL Azure Federation without losing uniqueness…
Mark13426
  • 2,569
  • 6
  • 41
  • 75
-1
votes
1 answer

Can I connect the MsSQL Server using Federated Engine in MySQL?

Is it possible to connect a SQL Server Database using the Federated Engine in MySQL? I have reviewed the documentation and it appears that the Federated Engine only connects natively to MySQL. I also found this article: You can use the SQL Gateway…
Ziyodullo
  • 13
  • 1
-2
votes
1 answer

Best practice, Application architecture MySQL

i must design a system which unifies 4 applications, these applications share a lot of information (which at the current system, the information is duplicate in databases). My first idea was to use a distributed database system in order to avoid all…
user1521944
  • 317
  • 1
  • 2
  • 14
1 2
3