Question:
Enter query statement Load CSV with headers from“ file:///hudong_pedia.csv "As line error reported:
the reason is that the statement is not complete. Load CSV should be used in combination with create or merge
for example:
LOAD CSV WITH HEADERS FROM "file:///C:/dir/file.csv" AS row
CREATE (n:Label {attributeName: row.columName});
Reference link: link
There was a problem installing Grammarly’s word plug-in, prompting that the plug-in could not be loaded. The solution is as follows
1. Uninstall Grammarly
2. Run the installer
3. When the welcome to grammar box pops up, press shift and control, and click get started. In the next step, you can see install for all users and check it.
Then follow the steps to install
Re open word and log in to the Grammarly account!
Article catalog
1 error recurrence 2 causes and Solutions
1 error recurrence
ERROR queue.BoundedInMemoryExecutor: error producing records0]
org.apache.parquet.io.ParquetDecodingException: Can not read value at 1 in block 0 in file hdfs://hdp-yl-1:8020/user/testJoin/test_join27/join/default/1d0f7a5b-fcbc-40aa-994d-ada47e3a3257-0_0-59-5054_20211119171950.parquet
2 causes and Solutions
The reason for the error is that the data types of the fields of the table to be written and the fields of the destination table are different.
The solution is to reset the data type of the written data. See the following example.
write_df2 = write_df2.withColumn("superior_emp_id",col("superior_emp_id").cast("string"))
Previous SQL writing:
"SELECT * FROM " + table + " LIMIT "
Change to the current wording:
SELECT * FROM " + schema +"." + table + " LIMIT "
Add the schema when querying
RuntimeError: CUDA out of memory. Tried to allocate 600.00 MiB (GPU 0; 23.69 GiB total capacity; 21.82 GiB already allocated; 115.25 MiB free; 21.87 GiB reserved in total by PyTorch)
Runtime error: CUDA out of memory. Attempt to allocate 600.00 MIB (GPU 0; 23.69 gib total capacity; 21.82 gib allocated; 115.25 MIB free; pytorch reserves a total of 21.87 GIB)
reason
A similar bug is due to insufficient video memory
Solution 1: release the video memory
First fuser - V/dev/NVIDIA * or sudo fuser - V/dev/NVIDIA * , view the processes running on the GPU recently, and then sudo kill the relevant process number.
Of which:
Fuser: it can display which program is currently using a file, mount point, or even network port on the disk, and give the details of the program process – V: detailed mode/dev/NVIDIA *: all NVIDIA related interfaces (such as GPU)
Solution 2: turn down the batch size
If it is not enough after releasing part of the video memory, you can reduce the batch size
Reference:
after NVIDIA GPU kill process, the video memory is still unclear
It’s convenient to use pychart remote debugging program, but PLT can’t display pictures.
You can refer to pycham to remotely connect to the server and display the picture_ Cowboy does not catch a cold blog – CSDN blog
The following is the troubleshooting of errors reported by Matplotlib. Use (‘tkagg ‘) during the recent use of Matplotlib. Record it:
Use the remote server debugger. In order to display the picture, modify matplotlib.use to report an error.
Cannot load backend 'TkAgg' which requires the 'tk' interactive framework, as 'headless' is currently runningXshell failed to open successfully. The error is eliminated after restarting xshell and xming.
But xming doesn’t pop up a window to display pictures. Restart debugging, here comes 
again
Then the above problem is probably not xshell and xming. Check env in the terminal and see display = localhost: 12.0
Recheck the pycharm running configuration. First clear the environment variable
Delete the display environment variable and display successfully.
After debugging and looking again, the error 
is reported again.
Check env again, display = localhost: 10.0
Add display = localhost: 10.0 again, the debugging is successful, try again, no problem, OK
Error when starting Zeppelin Zeppelin process died [FAILED]
That’s because your environment variable/etc/profile Zeppelin is configured in_ Home, but the path is wrong
Zeppelin documentation:
Zeppelin · YuQue
During the installation of Pikachu vulnerability shooting range, the processing methods of connecting to MySQL database and reporting errors are as follows:
1. Confirm that the database can be connected normally. Try connecting with tools. If it is not normal, please check the configuration problems such as service, user name and password
2. Modify the IP address, user name and password of the database in config.inc.php to the IP, user name and password of the database. Both the root directory and pkxss have this file and need to be modified.
Config.inc.php in the root directory \ pkxss \ Inc also needs to be modified. It’s difficult.
1. Problem description
A piece of Python code runs normally on the local ide. After it is deployed to the server for operation, a modulenotfounderror: no module named ‘xxx’ error occurs.
2. Cause of problem
The package of other files (self written package, not installed by PIP) is introduced into the code. What’s the problem import that line.
The reason for the error is that the path on the server side is different from our local path.
3. Solution example
To solve this problem, you can add the following code at the top of your code:
import sys
import os
sys.path.append(os.path.dirname(sys.path[0]))perhaps
import sys
import os
BASE_DIR = os.path.dirname(os.path.dirname(os.path.abspath(__file__)))
sys.path.insert(0, BASE_DIR)4. The above codes of sys.Path.Append() and sys. Path.Insert() can ensure that you can switch to the directory where the currently executed script is located at any time, which can be adjusted according to the directory structure where your script is located.
Used in Python programs import xxx, the python parser will search XXX in the current directory, installed modules and third-party modules. If it fails to search, an error will be reported.
sys.path The module can dynamically modify the system path. The path imported by this method will become invalid after the python program exits.
sys.path It’s a list, so it’s easy to add a directory in it. After adding, the new directory will take effect immediately. In the future, every time import operation may check this directory.
1. sys.path.append()
In the sys.path temporary end of the list to add the search path, convenient and concise import other packages and modules. The path imported by this method will become invalid after the Python program exits.
Example:
import sys
sys.path.append('..') # Indicates to import the upper directory of the current file into the search path
sys.path.append('/home/model') # absolute path
from folderA.folderB.fileA import functionA
2. sys.path.insert()
You can define the search priority. The sequence number starts from 0, indicating the maximum priority, sys.Path.Insert() is also a temporary search path, which will become invalid after the program exits.
Example:
import sys sys.path.insert(1, "./model")
About the error “version 1.8.0 301 of the JVM is not suitable for this product. Version: 11 or greater is required.”
1. Download Windows 64 bit (zip) under community from the official website of dbaver, and download and unzip it directly
2. After decompression, open the directory file, find dbeaver.exe and create a shortcut
3. Right click the shortcut and properties, add – VM D:/bigdata/software/JDK/bin/javaw.exe after the “target” path, and click apply and OK.
Generally, after performing the above operations, you can normally open the dbeaver shortcut. But some computers still can’t be turned on for some reasons. I checked many methods on the Internet. In the configuration file of dbaver, insert two lines above – vmargs:
-vm
D:/bigdata/software/jdk/bin/javaw.exe
However, the error version 1.8.0 is still reported when dbeaver is started on my computer_ 301 of the JVM is not suitable for this product. Version: 11 or greater is required.
I tried many methods on the Internet and still couldn’t solve it. Finally, I accidentally found that I put it in the dbeaver configuration file
-vm
D:/bigdata/software/jdk/bin/javaw.exe
Insert it into the next two lines of – vmargs. After saving, create a new shortcut and repeat step 3.
be careful!!! Be sure to add these two lines under – vmargs
Synchronous update: error from dbeaver startup ➕ Installation configuration – brief book (Jianshu. Com)
Another error was reported during Android development. This is a version error. The first step is to synchronize the versions
error message:
Android studio error: gradle project sync failed. Please fix your project and try again
1. Version synchronization:
1.1 file> sync project with android gradle
If you succeed, you don’t have to look at the following
1.2 error reporting:
It can be seen or not solved:
It should be the version problem. If we can’t download it, we can download it directly manually (check the network first, and the agent has no problem, but it still can’t be solved)
2. Modify proxy parameters:
Agent:
2.1 open file> setting> Search proxy
2.2 configuration information
The address and port of the agent shall be filled in as follows:
URL: http://127.0.0.1:1080/pac
2.3 check whether the Ping is connected
Still not!
3. Manual Download
So let’s continue:
3.1 open the gradle wrapper properties file
3.2 download
Download the gradle in the last line of the website. Note that the version must be consistent. Download whatever he puts down.
3.3 modifying environment variables
Remember to modify the gradle environment variable in the computer:
3.4 modify the compilation environment configuration
Then unzip it, modify the gradle configuration in the environment, and it’s OK.
You can see that my environment is OK now:
Error in compiling Trust: error [e0061]: this function takes 1 argument but 2 arguments were supplied
I didn’t find the relevant information. The preliminary judgment may be the problem of the version, because the code can be compiled in a low version.
Solutions are for reference only:
Error code:
let secret_number = rand::thread_rng().gen_range(1, 101);Correct code:
let secret_number = rand::thread_rng().gen_range(1..101);Compile after modification.