Forums

chat_bubble_outline HBase replication
visibility 3
thumb_up 0
comment 2
access_time 6 days ago
more_vert
visibility 30
thumb_up 0
comment 4
access_time 2 months ago
more_vert
visibility 12
thumb_up 0
comment 3
access_time 3 months ago
more_vert
visibility 10
thumb_up 0
comment 6
access_time 3 months ago
more_vert
visibility 121
thumb_up 0
comment 0
access_time 9 months ago
more_vert
visibility 737
thumb_up 0
comment 1
access_time 9 months ago
more_vert
visibility 434
thumb_up 0
comment 3
access_time 2 years ago
more_vert
visibility 84
thumb_up 0
comment 0
access_time 2 years ago
more_vert
visibility 155
thumb_up 0
comment 0
access_time 2 years ago
more_vert
visibility 601
thumb_up 0
comment 0
access_time 2 years ago
more_vert
#1792 Re: HBase replication access_time6 days ago

Hi Raymond, tanks for quick pick-up on the question. Yes, the slaves are up and as of slow network - let me check on the monitoring, let's see if there are any bottlenecks. Will update after checks )

#1791 Re: HBase replication access_time6 days ago

Hi Andrey,

My knowledge in HBase is basic hence won't be able to suggest much in this domain. Is the network I/O slow between your clusters? And also are your slave (replication target) clusters down?


#1790 Re: 是否支持Markdown格式编辑文章内容 access_time17 days ago

Markdown is now supported.

Refer to article: New feature - Markdown editor

#1789 Re: C# - Get Current and Last Month Start and End Date access_time18 days ago

Thanks for sharing AJ and welcome to Kontext. If you want to be even more accurate, you can also consider milliseconds as there might be possibilities that some purchases will land on the last second.

A AJ
#1788 Re: C# - Get Current and Last Month Start and End Date access_time19 days ago

the best way to avoid this if by using the Month function of sql (you can query using SqlDataAdapter or SqlCommand at your like) 

SELECT  *  FROM  myOrders WHERE MONTH(date_column) = 12 AND YEAR(date_column) = 2022; 

This will be more accurate and give you all records of December 2022 no matter the time ;)

A AJ
#1787 Re: C# - Get Current and Last Month Start and End Date access_time19 days ago
Thank you Raymond, it was very helpful for me! To anyone that needs the very last instance of the end date, just edit monthEnd and lastMonthEnd to:
var monthEnd = monthStart.AddMonths(1).AddSeconds(-1);
var lastMonthEnd = monthStart.AddSeconds(-1);

This will output for example (it's January 2023)
monthEnd = 1/31/2023 11:59:59 PM
lastMonthEnd = 12/31/2022 11:59:59 PM

This works in my shop in the case let's say I registered a purchase on 12/31/2022 10:05 AM, the LastMonthEnd will originally output the last day of the month but just at 12/31/2022 12:00:00 AM, so when you look up for records of December 2022 that purchase won't count.

If not expert with queries (like me) we would normally search between two dates with '<=' and '>=' operators and this won't count that purchase unless using the edit above, for example I used LINQ to count my purchases of the current month in a filled DataTable:

int currMonthOrders = dataSet1.myOrders.AsEnumerable().Where(row => row.Field<DateTime>("yourDateColumn") >= monthStart && row.Field<DateTime>("yourDateColumn") <= monthEnd).Count();

label1.Text = "You have done " +currMonthOrders.ToString("N0")+ " purchases this month";
#1786 Re: Error when connecting to oracle database in pyspark access_time21 days ago

I'm glad it works for you.

#1785 Re: Error when connecting to oracle database in pyspark access_time22 days ago

Thanks Kontext. I have tried to follow that web https://kontext.tech/article/1060/pyspark-read-data-from-oracle-database

That was successful.

Version of jdk is 1.8.0_352, open jdk 64-bit server VM.

All of logs I have shown above when I ran that statement code.

#1784 Re: Install Windows Subsystem for Linux on a Non-System Drive access_time22 days ago

Did you follow the exact steps in the guide? The error you encounter usually is caused by that fact the file to unzip us big a zip file. You can try downloading the file through browser and then unzip using GUI tools like 7zip and then follow other steps to install.

G Graham
#1783 Re: Install Windows Subsystem for Linux on a Non-System Drive access_time23 days ago

I uninstalled everything then tried again and got this exception:-

"New-Object : Exception calling ".ctor" with "3" argument(s): "Zip 64 End of Central Directory Record not where
indicated."
At
C:\WINDOWS\system32\WindowsPowerShell\v1.0\Modules\Microsoft.PowerShell.Archive\Microsoft.PowerShell.Archive.psm1:934
char:23
+ ... ipArchive = New-Object -TypeName System.IO.Compression.ZipArchive -Ar ...
+                 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidOperation: (:) [New-Object], MethodInvocationException
    + FullyQualifiedErrorId : ConstructorInvokedThrowException,Microsoft.PowerShell.Commands.NewObjectCommand"

So my system is still trying to use the "C" drive, didn't get this last time but it installed correctly, just on my C drive.