milvus-sdk-java icon indicating copy to clipboard operation
milvus-sdk-java copied to clipboard

The result of milvusclient.query is not expacted after use bulk load json file

Open yongpengli-z opened this issue 3 years ago • 0 comments

details: 1.the rows of json file need >=30(the result is correct when the rows is <=20) 2.both row_based and column_based

steps: 1.Create collection: String collectionName="Collection_"+ MathUtil.getRandomString(10); FieldType fieldType1 = FieldType.newBuilder() .withName("book_id") .withDataType(DataType.Int64) .withPrimaryKey(true) .withAutoID(false) .build(); FieldType fieldType2 = FieldType.newBuilder() .withName("word_count") .withDataType(DataType.Int64) .build(); FieldType fieldType3 = FieldType.newBuilder() .withName(CommonData.defalutVectorField) .withDataType(DataType.FloatVector) .withDimension(128) .build(); CreateCollectionParam createCollectionReq = CreateCollectionParam.newBuilder() .withCollectionName(collectionName) .withDescription("Test"+collectionName+"search") .withShardsNum(2) .addFieldType(fieldType1) .addFieldType(fieldType2) .addFieldType(fieldType3) .build(); R<RpcStatus> collection = BaseTest.milvusClient.createCollection(createCollectionReq); 2. Upload json file to minio : FileUtils.fileUploader(path,"bigJson0.json","bigData"); 3. Bulk load R<ImportResponse> bulkload = milvusClient.bulkload(BulkloadParam.newBuilder() .withCollectionName(newColltcion) .addFile("bigData/bigJson0.json").withRowBased(false) .build()); 4. query: String query_Param = "book_id in [2,4,6,8]"; List<String> outFields=Arrays.asList("book_id","word_count"); QueryParam queryParam= QueryParam.newBuilder() .withCollectionName(newColltcion) .withOutFields(outFields) .withExpr(query_Param) .build(); R<QueryResults> queryResultsR = milvusClient.query(queryParam); QueryResultsWrapper wrapperQuery = new QueryResultsWrapper(queryResultsR.getData()); System.out.println("query book_id:"+wrapperQuery.getFieldWrapper("book_id").getFieldData()); System.out.println("query word_count:"+wrapperQuery.getFieldWrapper("word_count").getFieldData());

image bigJson0.json.zip

yongpengli-z avatar Jun 06 '22 01:06 yongpengli-z